Compatibility with select() syntax

[nmoreaud]

SQLAlchemy recommends a new way of writing ORM queries, using select(): https://docs.sqlalchemy.org/en/14/changelog/migration_20.html Could you update this library to support it?

Currently, it triggers errors such as: 'Select' object has no attribute '_compile_state'

[harunurkst]

facing same issue, AttributeError: 'Select' object has no attribute 'count'

[tomviner]

As a new co-maintainer of this repo, I can say that we'd be happy to review a pull request. I don't have much time to work on this myself though.

[phillipuniverse]

@tomviner this should be fixed in #84