paleolimbot commented on issue #111:
URL: https://github.com/apache/sedona-db/issues/111#issuecomment-3310223085
Agreed! It's safer and more pythony to do the parameterized bits.
> It would be especially sweet if other objects (like dates & Shapely
objects) could be parameterized too!
Everything except spatial objects aren't much of a technical challenge
(anything that "just works" in `payarrow.array()`). Getting extension type
objects are a bit trickier, particularly if we want to handle nested lists or
structs that contain them.
Some prior art from DuckDB:
```python
import duckdb
duckdb.sql(
"SELECT * FROM (VALUES (1), (2), (3)) AS t(v) WHERE v > $cutoff",
params={"cutoff": 1.5},
)
#> ┌───────┐
#> │ v │
#> │ int32 │
#> ├───────┤
#> │ 2 │
#> │ 3 │
#> └───────┘
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
