deparse altered "CREATE TABLE" statement, removed quotes from column name

[divyenduz]

Original query (with fingerprint 45a041188bab2ec5):

CREATE TABLE public.ci_builds_runner_session (
    id bigint NOT NULL,
    build_id integer NOT NULL,
    url character varying NOT NULL,
    certificate character varying,
    "authorization" character varying
)

Deparsed query (with fingerprint 0):

CREATE TABLE public.ci_builds_runner_session (
 	id bigint NOT NULL,
	build_id int NOT NULL,
	url varchar NOT NULL,
	certificate varchar,
	authorization varchar 
);

And since authorization is a keyword, the deparsed query fails to parse again.

To reproduce:

const fs = require('fs')
const { parse, deparse } = require('pgsql-parser');

async function main() {
    const stmts = parse(`
      
CREATE TABLE public.ci_builds_runner_session (
    id bigint NOT NULL,
    build_id integer NOT NULL,
    url character varying NOT NULL,
    certificate character varying,
    "authorization" character varying
)
    `)
    const stmts2 = deparse(stmts[0])
    console.log(stmts2)
}

main()

Schema at https://github.com/prisma/database-schema-examples/tree/main/postgres/gitlab

[pyramation]

Thanks so much for the detailed issue — and apologies for the delay! I've been building this deparser from the ground up, so I really appreciate your thorough input and patience.

I've just published the updated package. Please give it a try and let me know if you run into any other issues!