Is there an extensible SQL like query language that is safe for exposing via a public API?
- by Lokkju
I want to expose some spatial (and a few non-spatial) datasets via a public API.
The backend store will either be PostgreSQL/PostGIS, sqlite/spatialite, or CouchDB/GeoCouch.
My goal is to find a some, preferably standard, way to allow people to make complex spatial queries against the data. I would like it to be a simple GET based request.
The idea is to allow safe SQL type queries, without allowing unsafe ones. I would rather modify something that is off the shelf than doing the entire thing myself.
I specifically want to support requesting specific fields from a table; joining results; and spatial functions that are already implemented by the underlying datastore.
Ideas anyone?