Thanks for publishing this database! While trying to explore it using ibis I ran into some issues around types and type inference (we use SQLAlchemy for type inference):
SQLite has no STRING type, for string type affinity you need some type name with TEXT, CHAR, or CLOB in it. A STRING type actually has NUMERIC type affinity, which makes ibis think these columns contain decimal values. See section 3.1 in the sqlite docs.
SQLite has no FALSE value, you want to use 0 for a false default.
Thanks for publishing this database! While trying to explore it using ibis I ran into some issues around types and type inference (we use SQLAlchemy for type inference):
STRINGtype, for string type affinity you need some type name withTEXT,CHAR, orCLOBin it. ASTRINGtype actually hasNUMERICtype affinity, which makesibisthink these columns contain decimal values. See section 3.1 in the sqlite docs.FALSEvalue, you want to use0for a false default.