You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Feature request: propagate AT (time travel) and DuckLake virtual columns (snapshot_id, rowid) through query_table()
What I'm trying to do
query_table(table_names, [by_name]) is the natural way to scan several DuckLake
tables dynamically in a single FROM clause (it expands to a UNION ALL, or UNION ALL BY NAME when the second argument is true). I'd like to combine this
with DuckLake's time-travel and row-lineage features, e.g.:
SELECT snapshot_id, rowid,*FROM query_table([x, y, z], 1) AT (TIMESTAMP=> now());
i think it would be cool to have AT clause and virtual column support.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
Feature request: propagate
AT(time travel) and DuckLake virtual columns (snapshot_id,rowid) throughquery_table()What I'm trying to do
query_table(table_names, [by_name])is the natural way to scan several DuckLaketables dynamically in a single
FROMclause (it expands to aUNION ALL, orUNION ALL BY NAMEwhen the second argument is true). I'd like to combine thiswith DuckLake's time-travel and row-lineage features, e.g.:
i think it would be cool to have
ATclause and virtual column support.All reactions