connector-x
connector-x copied to clipboard
how to query temporary table?
Connector-X is renowned for its swift data table queries, but I need to retrieve results that require several steps of computation through temporary tables, like
CREATE TEMP TABLE t1 AS ...;
CREATE TABLE t2 AS ...;
...
SELECT * FROM tn ...;
CANNOT use the WITH clause approach; there is too much historical code, and the workload to refactor it would be too large. How can I utilize Connector-X for this situation?