Category:SMEQL: Difference between revisions

Line 1:

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

* '''calc'''(table, columnTable) // similar to SELECT clause in SQL

* filter(table, expression) // similar to WHERE clause in SQL

* '''filter'''(table, expression) // similar to WHERE clause in SQL

* group(table, columnTable) // roughly similar to GROUP BY in SQL

* '''group'''(table, columnTable) // roughly similar to GROUP BY in SQL

* join(table_1, table_2, expression)

* '''join'''(table_1, table_2, expression)

* leftJoin(table_1, table_2, expression)

* '''leftJoin'''(table_1, table_2, expression)

* orderBy(table, columnTable, [sequenceColumn]) // sorts or produces sequence numbers

* '''orderBy'''(table, columnTable, [sequenceColumn]) // sorts or produces sequence numbers

* union(table_1, table_2)

* '''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.