CTE support

[fuyfuy]

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]

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]

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

[fuyfuy]

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