patrick

It would be pretty cool to do something like this: ```python import ibis sql = """ SELECT * FROM lineitem LIMIT 5 result = ibis.postgres.convert_sql(sql) print(type(result)) print(result) """ ``` out:...

This also fails for the SQLite backend: ```python import ibis sconn = ibis.sqlite.connect('test_db.db') import sqlite3 conn = sqlite3.connect('test_db.db') import pandas as pd test_df1 = pd.DataFrame({ 'id': ['1', '1'], 'value': ['a',...

Funnily enough, the duckdb backend yields a different error: ```python RuntimeError: Binder Error: Referenced table "df1" not found! Candidate tables: "t1", "t0" LINE 3: ..._y, t0.value_y, t1.id, t1.value FROM (SELECT...

@cpcloud Postgres works in some cases. Using the same data uploaded to postgres: ```python dates_base = conn.table("dates") dates = ( dates_base .mutate(date_value=ibis.date(dates_base['date_year'], dates_base['date_month'], dates_base['date_day'])) ) ``` yields `date_value` with the...

> @p-a-a-a-trick I made a typo in the word "sessionize". Got it; thanks @ogrisel! I'll probably knock a few more of these out in the next couple of months. Let...

@frsann I got my DuckDB and postgres blocks to work using the underscore API - can you try that real quick and let us know? FWIW I think it's the...