1247Expressing SQL queries in JSON
- Apr 29, 2009Hi,
I'm developing a web front-end to our student database and I'd like to
let the users specify what fields they want in their view and be able to
filter and sort the data.
After some thinking I figured out that this all can be expressed by an
SQL query -- and it will end up generating an SQL query on the server.
So I made a JSON syntax like this:
which would generate an SQL query like this:
SELECT std_id, code, lastname, firstname FROM students
WHERE prog IN ('200A0','200A1') AND decision LIKE 'A%'
ORDER BY cote_mix DESC
But I feel like I'm re-inventing the wheel here...
Is there already a specification for expressing an SQL query in JSON?
[Non-text portions of this message have been removed]
- Next post in topic >>