@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

@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!

(issue 298)

thank you!