Hi everyone:
how can i convert that query into honeysql:
@abdullahibra I've never seen that syntax before -- cross join lateral
-- so I've no idea how to do that in HoneySQL.
It doesn't look like the PostgreSQL-specific extensions to HoneySQL in https://github.com/nilenso/honeysql-postgres support it either but that's where I suggest you open an issue to see if they'll add support.
You could also extend HoneySQL yourself to have that type of join 🙂