api zql call to include current date time

How do I include current date and time in the zql/api call please? Today  or Getdate do not work.

What native sql functions are available through the API please?

SELECT @Title, SubmissionDate, Today() FROM EnhancementRequest WHERE SubmissionDate>2024-10-07 ORDER BY Title DESC