search

taozhi8833998 / node-sql-parser

Parse simple SQL statements into an abstract syntax tree (AST) with the visited tableList and convert it back to SQL
https://taozhi8833998.github.io/node-sql-parser/
Apache License 2.0
750 stars 172 forks source link

Support CHECK constraints for column definitions in SQLite #1958

Closed 1ilit closed 3 weeks ago

1ilit commented 3 weeks ago

Would be awesome to be able to parse CHECKs

Database Engine SQLite

To Reproduce -the SQL that be parsed

CREATE TABLE users (age INTEGER CHECK(age >= 18));

-the node-sql-parser version v5.2.0 -the node version v18.20.3

Expected behavior Produce ast