Modin SQL API#
Modin’s SQL API is currently a conceptual plan, Coming Soon!
Plans for future development#
Our plans with the SQL API for Modin are to create an interface that allows you to intermix SQL and pandas operations without copying the entire dataset into a new structure between the two. This is possible due to the architecture of Modin. Currently, Modin has a query compiler that acts as an intermediate layer between the query language (e.g. SQL, pandas) and the execution (See architecture documentation for details).
We have implemented a simple example that can be found below. Feedback welcome!
>>> import modin.sql as sql
>>>
>>> conn = sql.connect("db_name")
>>> c = conn.cursor()
>>> c.execute("CREATE TABLE example (col1, col2, column 3, col4)")
>>> c.execute("INSERT INTO example VALUES ('1', 2.0, 'A String of information', True)")
col1 col2 column 3 col4
0 1 2.0 A String of information True
>>> c.execute("INSERT INTO example VALUES ('6', 17.0, 'A String of different information', False)")
col1 col2 column 3 col4
0 1 2.0 A String of information True
1 6 17.0 A String of different information False