search

go-jet / jet

Type safe SQL builder with code generation and automatic query result data mapping
Apache License 2.0
2.23k stars 110 forks source link

Inject "AS OF SYSTEM TIME" into FROM clause #280

Closed jetaggart closed 8 months ago

jetaggart commented 8 months ago

I'm using cockroachdb time travel queries and wondering if it's possible to inject "AS OF SYSTEM TIME" into the from clause as described here without resorting to raw sql: https://www.cockroachlabs.com/docs/stable/as-of-system-time

houten11 commented 8 months ago

Hmm, I think it is not possible. You'll have to use raw SQL.

jetaggart commented 8 months ago

I ended up combining squirrel with this to get the generated names from jet and build this dynamically.