sql_engine_from_location

PlasmaCalcs.tools.sql_tools.sql_engine_from_location(location)

returns sql engine implied by location string.

Possible results:

“memory”: sqlite3 in-memory connection

“sqlite”: sqlite3 connection to file

“postgres”: PostgreSQL connection to online database

location: str

implies sql connection, e.g. “:memory:”, filepath, or online database connection string.

postgresql connection string starts with “postgresql://” or “postgres://”.

Currently assumes any non-memory, non-postgres connection is a filepath,

without checking whether the file exists yet.