Skip to content

1.6.0a1

Pre-release
Pre-release
Compare
Choose a tag to compare
@tatiana tatiana released this 21 Apr 17:37

Feature

  • Add query_modifier to raw_sql, which users can use to define SQL statements to be run before and after the main query statement #1898

Example:

    from astro.query_modifier import QueryModifier
    @aql.run_raw_sql(
        results_format="pandas_dataframe",
        conn_id="sqlite_default",
        query_modifier=QueryModifier(pre_queries=["ALTER team_1", "ALTER team_2"]),
    )
    def dummy_method():
        return "SELECT 1+1"