Temporary tables and the query! macro

[Ekleog]

First, thank you for sqlx! I've only been using for a short while, but it already seems like a great tool to me! I'm submitting this feature request mostly to document the current absence of the feature, as implementing it would probably be a significant undertaking.

Is your feature request related to a problem? Please describe. In order to not have queries that take way too long, I want to use an SQL temporary table. However, when doing so, the query! and query_unchecked! macros seem to stop accepting any queries to the temporary table. While it makes sense for query! (because it requires knowing the order of the SQL statements), I would have expected query_unchecked to support temporary tables, as AFAICT it's supposed to not run checks?

Describe the solution you'd like Ideally, sqlx would notice when all queries are reasonably grouped, and would make query! work with temporary tables. However this seems far-fetched, so maybe just having query_unchecked! work with temporary tables would be good?

Describe alternatives you've considered Using non-macro versions of the queries does work, but means the API is much less elegant, with the need to try_get() everything

[ibotty]

That's the same issue like #3661. I think one should be closed.