Need feedback on ORM
Building an ORM, it is close to sql, want more transparency, less migration overhead and lightweight:
Note: Ignore short syntax 3 letters, these will be proper keywords, focus on other pain points and provide more feedback.
Sample:
```
rows = (
Order
.select(
Customer.name,
fn.sum(Order.total).as_("revenue")
)
.join(Customer, Order.customer_id == Customer.id)
.where(Order.status == "paid")
.group_by(Customer.name)
.having(fn.sum(Order.total) > 10000)
.order_by(fn.sum(Order.total).desc())
.limit(20)
.offset(10)
.all()
)
```
Will be supported in Python, rust, c#, Java, typescript and go.
Does anyone care? It will go on GitHub soon.
Have not finalized all the keywords yet, trying to be compliant with all supported langs and short but convey readability.
Tried to 3 letters for most keywords, to reduce verbose and multi lang support, I thought devs love short syntax, maybe not needed, other than keywords any other feedback is appreciated.
Also just like as, is or in are reserved in langs, what is good alternative?? Can as_ become aka()
q.sql()
q.explain()
q.args()
q.debug()
q.diff()
db.raw()
Hope each explains itself.