DELETE statement fails with Parser Error

[tharwan]

Hi I triggered another issue when issuing a DELETE:

from snowflake.sqlalchemy import URL
import sqlalchemy
import fakesnow
from sqlalchemy.ext.declarative import declarative_base

from sqlalchemy import Column, Integer

Base = declarative_base()


class TestTable(Base):
    __tablename__ = "testtable"
    id_col = Column(Integer, primary_key=True, autoincrement=False)
    val_col = Column(Integer)


with fakesnow.patch():
    engine = sqlalchemy.create_engine(
        URL(
            account="abc123",
            user="testuser1",
            password="0123456",
            database="testdb",
            schema="public",
        )
    )

    TestTable.__table__.create(engine)

    with engine.connect() as con:
        ins = TestTable.__table__.insert().values(id_col=1, val_col=10)
        con.execute(ins)
        ins = TestTable.__table__.insert().values(id_col=2, val_col=20)
        con.execute(ins)

        con.execute("CREATE TABLE TESTTABLE2 AS FROM TESTTABLE")

        print(con.execute("SELECT * FROM TESTTABLE").fetchall())
        print(con.execute("SELECT * FROM TESTTABLE2").fetchall())

        print(
            con.execute(
                "DELETE FROM TESTTABLE2 USING TESTTABLE WHERE TESTTABLE.id_col = TESTTABLE2.id_col"
            ).fetchall()
        )

Results in:

duckdb.duckdb.ParserException: Parser Error: syntax error at or near "FROM"
LINE 1: DESCRIBE DELETE FROM TESTTABLE2 USING TESTTABLE WHERE T...

This looks related to #38 for me as it also happens in the describe.

[tharwan]

@tekumara any hints how I could maybe contribute here with a PR? Where should the logic go to exclude deletes from being "described"?

[tekumara]

That would be great if you want to have a go. We'd need something very similar to f1187b1, including a minimal test case that mirrors what Snowflake returns for a description.