How can I execute a select query that doesn't work...

# exposed

[Daniel]

How can I execute a select query that doesn't work with any table(SELECT SYSDATETIMEOFFSET()) ? All the examples I found seem to require calling select on ColumnSet

[Daniel]

I figured it out by going through the source. Donť know if its the expected use for it, but there is a special object Table.Dual that makes the query builder skip adding `FROM`clause if used. So this now works:

Table.Dual.slice(CustomTimeStampFunction("SYSDATETIMEOFFSET")).selectAll()

[Alexey Soshin]

You can also use exec() function for that