Anonymous user
Category:SMEQL: Difference between revisions
no edit summary
No edit summary |
No edit summary |
||
Line 1:
{{language|SMEQL
SMEQL is a draft query language that is meant to solve the shortcomings and annoyances of [[SQL]]. SMEQL stands for "structured meta-enabled query language" (pronounced "smeegle").
Line 42:
Here's a brief summary of common SMEQL operators:
* '''calc'''(table, columnTable) // similar to SELECT clause in SQL
* '''filter'''(table, expression) // similar to WHERE clause in SQL
* '''group'''(table, columnTable) // roughly similar to GROUP BY in SQL
* '''join'''(table_1, table_2, expression)
* '''leftJoin'''(table_1, table_2, expression)
* '''orderBy'''(table, columnTable, [sequenceColumn]) // sorts or produces sequence numbers
* '''union'''(table_1, table_2)
A "column table" is merely a way to represent or store column information in tabular form. SMEQL provides a shortcut syntax that is similar to an SQL "WHERE" clause. Any place above where a column-table is required, one can use the shortcut syntax within square brackets "[...]". Column tables potentially allow you to "calculate" column lists instead of having to type them in manually.
| |||