Re: Proper way of using expr in complicated queries

[Luis Silva]

Hi!

Sorry for the late reply...

The INTERVAL isn't supported... that's why it fails when using table().where();

Solution is to use the general Session.sql();

There you can pass arguments using ? (named binds are not possible).

So your query would be:

auto sql = session.sql("SELECT * FROM table
WHERE column1 IS NULL OR (column2 is NULL AND DATE_SUB(NOW(), INTERVAL ? SECOND) > column1);");

then to execute:
auto result = sql.bind(10).execute();

Hope it hepls.

Cheers,
Luís