Postgres generated columns produce a syntax error

[stereosteve]

Great project thank you for creating this!

Is it known what version of postgres features the parser supports? I tried to use a generated column:

create table descriptions_md5 (
    id varchar(32) GENERATED ALWAYS AS (MD5(txt)) STORED,
    txt text,
    primary key (id)
);

Produces error:

# package db
sql/schema.sql:1:1: syntax error at or near "("

[kyleconroy]

sqlc relies on https://github.com/lfittl/pg_query_go to parse SQL. That project currently uses the PostgreSQL 10 parser. The "GENERATED ALWAYS AS ..." syntax was introduced after PostgreSQL 10, hence the syntax errors. I've opened up an issue to get pg_query_go updated for PostgreSQL 12: lfittl/pg_query_go#26