PQLite: investigate query language

[numb3r3]

Now, the filtering conditions only support AND combination.

The goal is to convert the following condition into SQL WHERE Clause (support both of AND and OR)

The input DSL

{"and": [
    {"eq": ("foo", 3)},
    {"gt": ("bar", 4)},
   ]
}

The resulting SQL WHERE Clause:

WHERE foo = 3 AND bar > 4

• https://julien.danjou.info/writing-your-own-filtering-dsl-in-python/
• https://codereview.stackexchange.com/questions/174037/small-dsl-converting-json-to-mssql-query

[numb3r3]

The slack discussion thread https://jinaai.slack.com/archives/C02AC4T8Y5T/p1638538701411900