SQLAlchemy Engine

[cosmicBboy]

Starting to work on #381 in earnest, I just wanted to keep in mind how exactly this execution Backend idea would play well with using SQLAlchemy to finally implement validation at the persistence layer (i.e. on the SQL db itself instead of in-memory dataframes).

Keeping track of various resources here:

• for composing select statements with checks: https://stackoverflow.com/questions/34847869/sqlalchemy-using-a-cte-from-a-subquery-w-from-clause-specified-as-literal-te