proj-plbook-plChQueryLangs

Table of Contents for Programming Languages: a survey

Chapter : Query languages and graph languages

SQL

Example:

" Here’s an example. Let’s say we need data to create a “California revenue Q3” report.

You can create this report by writing one line of SQL that magically:

Fetches users from the California table Sorts the data Totals the data Orders the data so you can show one column that says “California revenue Q3 2017”

This is what the one line of SQL would like look:

SELECT SUM(Value_USD) AS California_Revenue_Q3 FROM Transactions WHERE Location = 'California' AND DATEPART(q, Date) = 3 AND YEAR(Date) = 2017;

And if we wanted to break it down by location the SQL would be as follows:

SELECT Location, SUM(Value_USD) AS Revenue_Q3 FROM Transactions WHERE DATEPART(q, Date) = 3 AND YEAR(Date) = 2017 GROUP BY Location ORDER BY Location;

And if we wanted the top five areas by revenue:

SELECT TOP 5 Location, SUM(Value_USD) AS Revenue_Q3 FROM Transactions WHERE DATEPART(q, Date) = 3 AND YEAR(Date) = 2017 GROUP BY Location ORDER BY SUM(Value_USD) DESC; " -- [1]

Tutorials

Courses

Linq

htsql

MDX

xpath

I think 1.0 is not Turing-complete, but 2.0 is? http://homepages.inf.ed.ac.uk/wenfei/cs2/lecture/ln3.pdf

XQuery

Extends XPath. Turing-complete.

XQBE

Subset of XQuery. Not Turing-complete.

http://wwwconference.org/www2003/cdrom/papers/poster/p291/p291-braga.html

gremlin

Turing complete.

GP

https://www.cs.york.ac.uk/plasma/wiki/index.php?title=GP_(Graph_Programs)

For solving complex graph problems. Has a complete formal semantics.

SPARQL

GraphQL

http://facebook.github.io/graphql/

discussion:

MQL

http://wiki.freebase.com/wiki/MQL

ANDL

http://www.andl.org/ http://www.andl.org/welcome-to-andl/

EdgeDB

https://edgedb.com/blog/we-can-do-better-than-sql/

Opinions:

XMLPL

http://xmlpl.org