Would it be possible to support SQL strings to query deltalake from whatever source you desire? Similar to what PySpark does when you perform a read operation you can apply a full SQL string as a filter/
Use Case
sql_str = """
SELECT your_column
FROM your_table
ORDER BY your_column DESC
LIMIT 10
"""
delta_url = "..."
storage_options = {...}
dl: DeltaTable = DeltaTable(table_uri=delta_url, storage_options=storage_options)
df = dl.to_pandas(filters = sql_str)
Description
Would it be possible to support SQL strings to query deltalake from whatever source you desire? Similar to what PySpark does when you perform a read operation you can apply a full SQL string as a filter/
Use Case
Or something at the very least similar to this?