Closed
Description
Describe the bug
COMMENT ON [something] syntax
https://www.postgresql.org/docs/current/sql-comment.html
Database Engine
PostgreSQL
To Reproduce
-the SQL that be parsed: COMMENT ON COLUMN test_table.status IS 'new comment';
-the node-sql-parser 5.3.0
-the node version: 20.11.0
-error: SyntaxError: Expected "--", "/*", ":=", "=", "FOR", "TO", or [ \t\n\r] but "o" found. near 'on' at line 1
Expected behavior
Should be able to parse. Some common used like ON COLUMN, ON INDEX, ON TABLE, ON CONSTRAINT is ok.