Another example of something technically cool that we built recently is tinyquery, a pure-Python reimplementation of Google BigQuery suitable for very small data sets, which we're using for (fast) integration testing when building pipelines on top of the BigQuery API:

https://github.com/Khan/tinyquery