select_resources.py

conn = eng.connect()
user_id_parm = bindparam("user_id")

query = select([resource_table])\
    .where(and_(resource_table.c.user_id == user_id_parm,
                text("""resources.id not in 
                    (select resource_id from resource_deletions)""")))

result = conn.execute(query, user_id=user_id)