search

uwdb / Cosette

Cosette is an automated SQL solver.
BSD 2-Clause "Simplified" License
662 stars 54 forks source link

CTE support #34

Open fuyfuy opened 7 years ago

fuyfuy commented 7 years ago

Hey guys, are there any plans to work on CTE (common table expressions) support? They are a part of SQL standard, supported by most popular RDBM and their usage is widely considered to be best practice when there's a need for multiple (potentially nested) subquieries.

akcheung commented 7 years ago

Thanks for the suggestion @fuyfuy . I think this can be handled by allowing users defining relations based on queries (in some sense like a macro). What do you think @stechu ?

stechu commented 7 years ago

@fuyfuy Thanks for your suggestion. I think we can include CTE in the next version of Cosette.

fuyfuy commented 7 years ago

Thanks a lot! Cosette a is very interesting project, keep up the great work!