I'm sorry in case I miss something completely obvious. I just discovered siuba and found it appealing as an experienced R, but unfortunately I did not get far yet :(
@christophscheuch , it is because siuba is using an old version of sqlalchemy package.
Try installing version 1.4.32 (pip install sqlalchemy==1.4.32). For me, that worked.
I tried to replicate the minimal example from the website using an in-memory SQLite database:
I get the following error:
Also the direct import does not work as this chunk
returns
I guess it is related to this recent commit where they renamend it to
ReadOnlyColumnCollection
: https://github.com/sqlalchemy/sqlalchemy/commit/4e754a8914a1c2c16c97bdf363d2e24bfa823730#diff-31621fcf3d90e3d9b15029c8dc1ccbf0b7c9f320a0d04471ec0e68ae02e4ec78L1502I'm sorry in case I miss something completely obvious. I just discovered
siuba
and found it appealing as an experienced R, but unfortunately I did not get far yet :(