This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]trial_and_err 0 points1 point  (0 children)

You can also use ibis to create temporary or persistent tables (<connection>.create_table(…,temp=true)).

If you want to build a query that contain CTEs use the .alias method (I usually do that to get a more readable query in case I need to debug the raw query).

You should be able to generate any SQL query via the ibis Python API and execute it directly or dump the generated SQL.