Method query

preswald/engine/managers/data.py:178–179

(self, sql: str)

        self._duckdb.execute(f"CREATE TABLE {self._table_name} AS SELECT * FROM df")

    def query(self, sql: str) -> pd.DataFrame:
        return self._duckdb.execute(sql.replace(self.name, self._table_name)).df()

    def to_df(self) -> pd.DataFrame:
        return self._duckdb.execute(f"SELECT * FROM {self._table_name}").df()