ddfql - Query language

ddfql is a query language created in 2016.

#2598on PLDB

9Years Old

Tags: queryLanguage
Early development of ddfql happened in https://github.com/open-numbers/
Read more about ddfql on the web: 1.

Example from the web:

{
 "select": {
   "key": ["geo", "year"],
   "value": [
     "population", "life_expectancy", "gdp_per_cap", "gov_type"
]
 },
 "from": "datapoints",
 "where": {
   "$or": [
{ // implicit $and
       "geo": "$geo",
       "year": { "$eq": 2015 },
     },
{ "population": { "$gt": 100000 } },
{ "gdp_per_cap": { "$gt": 1000 } },
{ "$and": [ // explicit $and
{ "$and": [ { "geo": “$geo” } ], // redundant and
{ "gdp_per_cap": { "$gt": 400, "$lt": 500 } },
{ "life_expectancy": { "$gt": 30, "$lt": 70 } }
]}
]
 },
 "order_by": ["life_expectancy", "population"],
 "join": {
   "$geo": {
     key: "geo",
     where: {
         "is--country": true,
       "latitude": { "$lte": 0 },
     }
   }
 },
 "language": "en"
}

Language features

Feature	Supported	Example	Token
Comments	✓	// A comment
Line Comments	✓	// A comment	//
Semantic Indentation	X