4 ms·
If you want more generic SQL tooling in Haskell, my project was just recently open sourced (https://github.com/uber/queryparser https://github.com/uber/querypar
by dllthomas 10y ago
If you want more generic SQL tooling in Haskell, my project was just recently open sourced (https://github.com/uber/queryparser https://github.com/uber/queryparser). It currently has support for Vertica, Hive, and Presto; adding support for more dialects isn't complicated. I'm working on cleaning it up for hackage.
- arnon 10y agoVery interesting! Do you do any sort of typechecking in this? FWIW, HsSqlPpp also supports various dialects. In SQream DB we use a custom dialect, while HsSqlPpp is mostly Postgres.
- dllthomas 10y agoTypechecking of the SQL statements? There was an internal branch where I was experimenting with that, but it didn't get landed before I left, and isn't in the squashed version. It was relatively simplistic - along the lines of "things tested for equality must share a type". It was also focused on domain-relevant types, not SQL type (/representation). > FWIW, HsSqlPpp also supports various dialects. In SQream DB we use a custom dialect, while HsSqlPpp is mostly Postgres. Nice. It'll be interesting to see where our implementation choices differed, and what we can learn from each other :)