search

upper / db

Data Access Layer (DAL) for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.
https://upper.io/
MIT License
3.54k stars 235 forks source link

using query builder with functions #657

Open bornjre opened 2 years ago

bornjre commented 2 years ago

what is best way to query sth like this using sql query builder (db.Cond)?

--- person around 5km

select * from person where person.xyz = 13 and ST_Distance(person.location, ST_MakePoint(11.5, 42.9)::geography) < 5000;