Closed
Description
Describe the bug
The parser throws a syntax error when it gets to ON
. It would be great if it recognized comments.
Database Engine
PostgreSQL
To Reproduce
-the SQL that be parsed
COMMENT ON TABLE users IS 'users table';
COMMENT ON TABLE "users" IS 'users table';
COMMENT ON COLUMN users.name IS 'first name and last name';
COMMENT ON COLUMN "users"."name" IS 'first name and last name';
-the node-sql-parser version
v5.3.2
-the node version
v18.20.3
Expected behavior
Output the ast