simple-sql-parser icon indicating copy to clipboard operation
simple-sql-parser copied to clipboard

Add a "sqlite" dialect

Open ad-si opened this issue 2 years ago • 2 comments

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
  }

ad-si avatar Sep 10 '22 14:09 ad-si

This should also include the new strict keyword (https://sqlite.org/stricttables.html)

ad-si avatar Sep 11 '22 18:09 ad-si

SQLite also supports columns without types:

CREATE TABLE simple (a, b, c)

ad-si avatar Feb 02 '23 08:02 ad-si