Clojurians Log v2

select abs(extract(epoch from first_timestamp_field - second_timestamp-field))

so, given this, I'm struggling to render using honeysql

i.e., (sql/call :abs (sql/call :extract ....)

if I try using :epoch :from, it puts commas in such as EPOCH, FROM,

if I try (sql/raw ["epoch from"]) it renders as extract(epoch from,

.

@dharrigan No idea. That's sort of outside HoneySQL's design parameters at the moment. I'd be interested to see proposed DSL syntax for making that sort of things easier...

HoneySQL is not very good at complex expressions right now 😞

No problem. I think I may either just write a stored proc and invoke it

Or hand craft the sql

I will have a ponder

Thanks Sean!