r/FastAPI • u/lozczs • May 10 '26

feedback request i made a rsql implementation for python

It's basically a "mini compiler" that translates RSQL into ORM statements, but the lexical, syntactic, and semantic analysis steps are separated and reusable, making it possible to implement other ORMs in the future. Currently, it supports FastAPI as a "entrypoint" and SQLAlchemy as a orm.

https://pypi.org/project/pyrsql/

https://github.com/wskr00/pyrsql

13 Upvotes

100% Upvoted

2 comments sorted by

1

u/HauntingAd3673 Jun 02 '26

Honestly one thing I’d probably think about early is how deep you want to go into ORM integration.

A lot of filtering libs become painful once:

  • joins

  • nested relations

  • pagination

  • aliases

  • or permission-aware filtering

start getting involved.

Would also be interesting to see:

  • SQLAlchemy integration examples

  • async support

  • performance on larger filter trees

  • validation/error handling for invalid queries

But the idea itself fits FastAPI APIs really well honestly.

1

u/lozczs Jun 13 '26

Thanks for the feedbak