Add column descriptions to generated typescript types docstring

[d9k]

There must be fields descriptions (comments)

1) in dumps in form of

COMMENT ON COLUMN public.authors.birth_town IS 'town of birth (test description)';

2) in generated typescript types as docstrings before corresponding field names.

SQL to get descriptions manually

select
    c.table_schema,
    c.table_name,
    c.column_name,
    pgd.description
from pg_catalog.pg_statio_all_tables as st
inner join pg_catalog.pg_description pgd on (
    pgd.objoid = st.relid
)
inner join information_schema.columns c on (
    pgd.objsubid   = c.ordinal_position and
    c.table_schema = st.schemaname and
    c.table_name   = st.relname
);

(thanks to https://stackoverflow.com/a/4946306/1760643)

[d9k]

Adding description in Supabase admin UI:

[d9k]

I was able to write script which grabs description info using SQL query via PostgreSQL connection to Supabase.

Supabase as single source of truth for fields descriptions can be very useful to construct form fields, for example.

[sweatybridge]

We will support dumping of comments in this PR https://github.com/supabase/cli/pull/1981

Typegen comments are tracked in this issue https://github.com/supabase/cli/issues/412