Anonymous user
Category:SMEQL: Difference between revisions
no edit summary
(New page: 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"). It is ...) |
No edit summary |
||
| (7 intermediate revisions by 4 users not shown) | |||
Line 1:
{{language|SMEQL
|site=http://www.c2.com/cgi/wiki?TqlRoadmap
|LCT=no
}}
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").
It is influenced by IBM's "Business-System 12" (BS-12) relational query language. BS-12 predated SQL, but was rejected over SQL because IBM felt it was too "mathy", potentially harming sales. However, it's math-like nature is also what makes it more powerful than SQL. It's designed to please nerds, not managers. (It uses "functional programming" to be more specific.)
The general syntax of an element is:
Line 12 ⟶ 17:
t2 = bar(t1, zog)
to get this:
t2 = bar(foo(blah), zog)
Line 24 ⟶ 29:
Here is a sample to whet your appitite:
srt = orderBy(Employees,
top = group(srt, [(dept) dept2, max(order) order])
join(srt, top, a.dept=b.dept2 and b.order - a.order < 6)
Line 31 ⟶ 36:
this table schema:
table: Employees
----------------
empID
Line 40 ⟶ 45:
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 "[...]" (not to be confused with "optional" syntax indicators). Column tables potentially allow you to "calculate" column lists instead of having to type them in manually.
More info can be found at: http://www.c2.com/cgi/wiki?TqlRoadmap
| |||