Fork me on GitHub
#honeysql
<
2022-05-07
>
vlad_poh21:05:06

I’d avoided honeysql and korma for years but playing with datalog rules prompted me to take another look. It's amazing! 2 questions how do I do subqueries and how do i call a function on an aliased column? Neither :%http://max.c.id nor :%max:http://c.id works

seancorfield21:05:49

You can't use the shorthand function call syntax on compound names. Do this instead: [:max :c.id]

seancorfield21:05:06

As for your other question, are you referring to something like this in the README? https://cljdoc.org/d/com.github.seancorfield/honeysql/2.2.891/doc/readme#nested-subqueries

seancorfield21:05:04

This section of the README should answer your other question about function calls: https://cljdoc.org/d/com.github.seancorfield/honeysql/2.2.891/doc/readme#functions