hasql-th VS sqlschm

Hasql is an ecosystem of libraries. To keep it simple, let’s limit ourselves to core hasql, hasql-transaction, and hasql-th. We’re using hasql 1.6.3.2 published in 2023.

unexpected '&'

https://github.com/nikita-volkov/hasql-th#error-example-1

There is also a Haskell port of the original PostgreSQL parser, implemented using megaparsec, which makes it highly flexible and hackable: https://github.com/nikita-volkov/hasql-th#implementation

I'd consider hasql-th a good example in what concerns databases. Otherwise, I just use aeson together with deriving-aeson and lens-aeson.

> The main reason why I ended up building a SQL engine was...just for entertainment. It's been fun learning about all the things

I also wrote an SQL parser [1] for SQLite schema. This was mainly for fun, but also to support the specificities of SQLite schema. I was not happy with the result of other parsers (including sqlglot).

[1] https://github.com/coast-team/sqlschm

SQL is a mess. It is difficult to find a parser that fulfills your needs.

A month ago, I needed a parser to parse SQLite schemas. SQLite has some edge case and I needed a lossless parsing to detect these edge cases.

I finally wrote my own parser [1] to fullfill my needs and to have some fun. This is for a POC project.

[1] https://github.com/coast-team/sqlschm