honeysql

Discussion of https://github.com/seancorfield/honeysql :slightly_smiling_face:
enn 2021-02-08T17:09:37.077500Z

@seancorfield I think you’re right that you can only have one WITH clause, but it can define multiple tables … is that supported by the new syntax? e.g. the first example here: https://www.postgresql.org/docs/9.1/queries-with.html

seancorfield 2021-02-08T18:02:47.079300Z

@enn Ah, thanks for that link -- I had only been looking at SQL Server and the docs seemed to indicate only one CTE can be defined but that PostgreSQL example makes it clear you can define multiple ones. I'll create and issue to reverse that optimization and make sure that example can be done with HoneySQL 2.0!

seancorfield 2021-02-08T18:04:51.079500Z

(issue 298)

enn 2021-02-08T18:13:43.079700Z

thank you!