Is it possible to convert the following mariadb query to honeysql

select * from zone for system_time all y

Well, yes, you could use :raw 🙂 Can you link to the docs for that syntax so I can understand what parts of the grammar it represents @kbosompem?

https://mariadb.com/kb/en/system-versioned-tables/#:~:text=SELECT%20*%20FROM%20t%20FOR%20SYSTEM_TIME%20ALL%3B

Thanks. https://github.com/seancorfield/honeysql/issues/407 It's an interesting piece of syntax. I'll have to think about how best to support it.

https://www.sqlshack.com/how-to-query-data-in-a-system-versioned-temporal-tables-in-sql-server/