Migrate SQL queries to SQLAlchemy for compat between sqlite and mysql

[arrrobase]

No description provided.

[arrrobase]

Also need to add a context manager to close connections after queries. Something like this:

from nems.db import Session

@contextmanager
def db_session():
    session = Session()
    try:
        yield session
        session.commit()
    except:
         session.rollback()
    finally:
         session.close()

with db_session() as session:
    session.add(object)

https://docs.sqlalchemy.org/en/13/orm/session_basics.html