Using in memory SQL engine .py

# Importing in memory SQL engine as mdsql 
# in the next couple of days you will import as follows
#  - import modin.experimental.sql as mdsql

# For now you can pip install the sql engine 'pip install pdsql' and include it as follows:
from dfsql import sql_query
import modin.sql as mdsql
mdsql.query = sql_query

# You can then define the query that you want to perform
sql_str = "SELECT App,Category,Rating FROM gstore_apps WHERE Price = '0'"

# And simply apply that query to a dataframe
result_df = mdsql.query(sql_str, gstore_apps=gstore_apps_df)

# Or, in this case, where the query only requires one table, 
# you can also ignore the FROM part in the query string:
query_str = "SELECT App, Category, Rating WHERE Price = '0' "

# mdsql.query can take query strings without FROM statement 
# you can specify from as the function argument
result_df = mdsql.query(query_str, from=gstore_apps_df)