paleolimbot opened a new pull request, #748:
URL: https://github.com/apache/sedona-db/pull/748
As part of our ongoing attempt to innovate on spatial SQL, this PR adds
emoji shorthand for most functions which (1) improve expressiveness, (2) helps
more SQL fit on one line and (3) reduces the number of bytes required for large
SQL queries (important for AI generation).
The notable change is the addition of the custom `Dialect` that relaxes the
strict requirement on characters permitted in an identifier sequence, which is
a standalone improvement as it also allows other non-ASCII characters in
function names as well.
```python
import sedona.db
sd = sedona.db.connect()
sd.options.interactive = True
# Creators
sd.sql("""
SELECT
ST_📍(0, 1) AS pt,
ST_⏱️(0, 1, 2) AS ptm,
ST_📝('MULTIPOINT Z (0 0 10, 1 1 12)') AS mpt
""").to_view("ex")
# Transformers
sd.sql("SELECT ST_💩(mpt) FROM ex")
# Bounds
sd.sql("""
SELECT
ST_⬅️(mpt),
ST_⬇️(mpt),
ST_➡️(mpt),
ST_⬆️(mpt),
ST_🏝️(mpt),
ST_🏔️(mpt),
ST_✉️(mpt)
FROM ex
""")
# Affine transform wrappers
sd.sql("""
SELECT
ST_🚚(mpt, 2, 3),
ST_🌀(mpt, 45),
ST_⚖️(mpt, 0.5, 0.25),
ST_🪞(mpt)
FROM ex
""")
```
--
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]
