simple-sql-parser
simple-sql-parser copied to clipboard
Add a "sqlite" dialect
Add an SQLite dialect to /Language/SQL/SimpleSQL/Dialect.lhs
-- | SQLite dialect
sqlite :: Dialect
sqlite = addLimit ansi2011
{ diBackquotedIden = True -- https://sqlite.org/lang_keywords.html
, diSquareBracketQuotedIden = True -- https://sqlite.org/lang_keywords.html
}
This should also include the new strict
keyword (https://sqlite.org/stricttables.html)
SQLite also supports columns without types:
CREATE TABLE simple (a, b, c)