Implement additional find operators (and relevant tests)

pudo / dataset

Easy-to-use data handling for SQL data stores with support for implicit table creation, bulk loading, and transactions.

https://dataset.readthedocs.org/

MIT License

4.78k stars 298 forks source link

Implement additional find operators (and relevant tests) #301

Closed abmyii closed 4 years ago

abmyii commented 5 years ago

Implements more find operators. Not sure if there was a (good?) reason for them not being implemented. My choices might not be ideal, and I'll be happy to modify them as you see fit.

pudo commented 4 years ago

hey @abmyii - I have two points here:

can we add some clear documentation on all these operators in the main documentation?
I'd like to somehow limit how much of SQL we emulate this way. Building a DSL for doing dict-based SQL queries in Python (like ES queries or MongoDB queries) would be a very nice project on it's own, but it feels like a massive endeavour and not something dataset was initially meant to do. Can we stop here?

abmyii commented 4 years ago

Sure. Are there any other libraries I can use together with dataset to parse those additional parameters? Perhaps the _args_to_clause should be replaced with a purpose-built parser library?