Can't run CREATE TEMPORARY TABLE queries with sqlc.

[Jille]

Version

1.13.0

What happened?

All DDL statements in queries.sql are parsed as schema definition, rather than as queries that can be executed at runtime.

I want to create temporary tables at runtime, so I can then CopyFrom into them and use UPDATE .. FROM .. to efficiently write back to a non-temp table.

Relevant log output

No response

Database schema

No response

SQL queries

No response

Configuration

No response

Playground URL

https://play.sqlc.dev/p/9a91120870ebfb6e91ab726c9495822a6403c2db27fbf036c07e976af9f794d3

What operating system are you using?

Linux

What database engines are you using?

PostgreSQL

What type of code are you generating?

Go

[kyleconroy]

Tracking here #1661

[sgielen]

I believe this is resolved in sqlc v1.25.0, although the release notes don't directly mention it - only that a different PostgreSQL query parser is now used, which may be relevant. If you open the Playground link on v1.24.0 you'll see the CreateTempTable query is not generated, but on v1.25.0, it is. (You may need to make a tiny change to the query.sql to get the playground to rerun codegen.)

[ZNackasha]

@sgielen can we get an example of how to do this?