sql: support general type names with typmods

[otan]

We currently do not support schema'd type names with typmods, e.g. public.geometry(linestring, 4326) in CREATE TABLE t(g public.geometry(linestring, 4326)). Users seeing this in v20.2 from IMPORT PGDUMP must remove the public. to get this to work (i.e. use geometry(linestring,4326) instead). Note public.geometry works today.

This is because complex_type_name does not take any optional attrs.

[otan]

cc @rmloveland we may want to document this as a limitation from importing PGDUMPs.

[rafiss]

@otan do you predict this to be a complex parsing change?

[otan]

potentially. i tried it and got shift/reduce errors :\