Mapping pydal syntax into data Google Datastore or the Firestore feels like trying to put a square peg in a round hole. It will never work very well. It will never support the fill SQL syntax. Some times does not work as expected. And cannot access all of the datastore/firestore APIs because some have no equivalent in pydal. Moreover Google appear to be deprecating the datastore and it is unclear if there is a future. The Firestore appear to be the future (for now).
So I decided to deprecate the datastore and add support for firestore since this is what Google recommends now. It is still a square peg in a round hole.
It is a lot of work to support both and I am not convinced there is any reason to support the legacy datastore.
If you want to try you are welcome.
I think as a first step anyway, if you could help a lot if you could test firestore support. It would help other users and be a learning experience. Even the source code is relatively short.
Massimo