Describe what's wrong
Incompatible with pandas boolean columns with none
How to reproduce
import chdb
df = pd.DataFrame({
'id': [1, 2, 3, 4, 5, 6, 7],
'bool_col': [True, np.nan, None, pd.NA, None, pd.NaT, False],
})
chdb.query("SELECT * FROM Python(df)", "DataFrame")
# The bool is recognized as string type