from sqlalchemy import text
from db import engine

def execute_sql(sql):

    with engine.connect() as conn:

        result = conn.execute(text(sql))

        return [
            dict(row._mapping)
            for row in result
        ]