ddfql is an actively used query language created in 2016.

4Years Old ?Users ?Jobs
  • ddfql first appeared in 2016
  • Have a question about ddfql not answered here? Email me and let me know how I can help.

Example code 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"
}

Last updated August 9th, 2020

Edit ddfql on GitHub