search

cycle / database

Database Abstraction Layer, Schema Introspection, Schema Generation, Query Builders
MIT License
54 stars 23 forks source link

💡 Using Common Table Expression (CTE) #139

Open Concentum opened 11 months ago

Concentum commented 11 months ago

I have an idea!

Please consider implementing a function to use a common table expression (CTE). in SelectQuery. This feature can greatly simplify complex queries and make them more understandable.

This might look like function withQuery() or withCTE()

roxblnfk commented 11 months ago

Or it might be some Fragment that contains Select object and alias.

I think it's a good feature after JSON functions