In DBIx::Class, when I generate a query using this syntax:
...
'Time(submitted_at)' => { '>' => 'Time(Now()-Interval ' . $wait_period . ' minute)' }
...
The generated query is perfect except for the fact that the function on the right hand side is in quotes.
... AND ( Time(submitted_at) > 'Time(Now()-Interval 5 minute)' ) ...
If it was not quoted then it would be correct. How would I do that?
Thanks, Rob