docs: undocumented use of raw_sql and parameters maybe a bug in BigQuery con

[dgarridoa]

Please describe the issue

Reading the docs and the code I am not sure what is the proper way to use query parameters in con.raw_sql. For instance, lets say that i want to perform a parameterized delete operation as follows:

import ibis
import ibis.expr.datatypes as dt

# ex: to bigquery
con = ...
cutoff = ibis.param("date")
query_parameters = {cutoff: date(2024, 10, 28)}
query = f"DELETE FROM dataset.table WHERE cutoff = @{cutoff.get_name()}"
con.raw_sql(query, params=query_parameters)

This approach kind of beat the purpose of using query parameters, because I have to pass the parameter name through string formatting. By the way ibis.param("date").name("cutoff") does not work, because param.op() is instance of Alias, therefore param.op().arg.name is used instead.

Code of Conduct

• I agree to follow this project's Code of Conduct

[cpcloud]

Thanks for the report. I'll investigate. We may not need to fiddle with Alias unwrapping here anymore.