"describe" can already be used a subsequery and the duckdb_prepared_statement_type API return DUCKDB_STATEMENT_TYPE_SELECT for a "describe" or "describe table" statement.
To Reproduce
with x as (describe) select * from x;
Not implemented Error: A CTE needs a SELECT
OS:
n/a
DuckDB Version:
0.10.2
DuckDB Client:
C
Full Name:
Karl Seguin
Affiliation:
n/a
What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.
I have tested with a stable release
Did you include all relevant data sets for reproducing the issue?
Not applicable - the reproduction does not require a data set
Did you include all code required to reproduce the issue?
[X] Yes, I have
Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?
What happens?
It should be allowed to use "describe" in a CTE.
"describe" can already be used a subsequery and the
duckdb_prepared_statement_typeAPI returnDUCKDB_STATEMENT_TYPE_SELECTfor a "describe" or "describe table" statement.To Reproduce
OS:
n/a
DuckDB Version:
0.10.2
DuckDB Client:
C
Full Name:
Karl Seguin
Affiliation:
n/a
What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.
I have tested with a stable release
Did you include all relevant data sets for reproducing the issue?
Not applicable - the reproduction does not require a data set
Did you include all code required to reproduce the issue?
Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?