search

zshamrock / dynosql

Run SQL queries against DynamoDB
GNU General Public License v3.0
3 stars 0 forks source link

Implement DQL as the main query syntax #39

Open zshamrock opened 5 years ago

zshamrock commented 5 years ago

Looks like https://dql.readthedocs.io/en/latest/topics/queries/select.html defines the good enough syntax for the SELECT statement, i.e.

SELECT
    [ CONSISTENT ]
    attributes
    FROM tablename
    [ KEYS IN primary_keys | WHERE expression ]
    [ USING index ]
    [ LIMIT limit ]
    [ SCAN LIMIT scan_limit ]
    [ ORDER BY field ]
    [ ASC | DESC ]
    [ THROTTLE throughput ]
    [ SAVE filename]

Although for now would be ok to skip THROTTLE, SAVE and KEYS IN parts.

zshamrock commented 5 years ago

As well to support DynamoDB functions in additions to the available SQL operators, like attribute_exists vs SQL exists.