I mostly use this now: https://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_sql_query.html https://pandas.pydata.org/pandas-docs/stable/generated/

I mostly use this now: https://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_sql_query.html https://pandas.pydata.org/pandas-docs/stable/generated/panda... Which is basically an easy to use API that turns a SQL query into an efficient columnar table in memory. Yes, this still requires writing actual SQL. And yes it does not help you insert or update data. But for 95% of uses it works well.