With a placeholder, the initial argument type is NULL which causes the planning process to fail:
import pyproj
import sedona.db
sd = sedona.db.connect()
url = "https://github.com/geoarrow/geoarrow-data/releases/download/v0.2.0/microsoft-buildings_point.parquet"
crs = pyproj.CRS('ESRI:102005').to_json()
sd.read_parquet(url).to_view("buildings")
sd.sql("""SELECT ST_Transform(geometry, $1) AS geometry FROM buildings""", params=(crs, ))
#> SedonaError: st_transform([WkbView(Planar, Some(AuthorityCode { auth_code: "OGC:CRS84" })), Arrow(Null)]): No kernel matching arguments
With a placeholder, the initial argument type is NULL which causes the planning process to fail: