Multiple CTEs + cryptic note about query planner failure + broken docs for supported SQL

[marco-alban-atomic]

Describe the problem

• Will readyset ever support multiple CTEs? We get an error saying "Cannot find table" with the name of the CTE
• We tried converting to nested subqueries and we get ""couldn't be added: MIR node '47' couldn't be lowered to dataflow""

To Reproduce
What did you do? Describe in your own words.

Any even basic query with multiple CTEs.

If possible, provide steps to reproduce the behavior:

1. Set up Readyset ...
2. Cache a query ...
3. Look at Readyset dashboard / log file / client app ...
4. See error

Expected behavior
Multiple CTEs should work or at least "MRI Node" error should be more descriptive

Environment

• Readyset version version={release-version: stable-250828, commit_id: e4188ae08793f19ee3ebc35f8db0bf6fd228f119, platform: x86_64-unknown-linux-gnu, rustc_version: rustc 1.89.0 (29483883e 2025-08-04), profile: release, opt_level: 3}
• Readyset deployment method Docker
• Upstream database and version Postgres 13.13
• Client app psql

Additional context
Is there a support channel? We tried slack but could not find anything there. No support email is available. We were hoping to be a paying customer but there does not even seem to be an official support email? Docs here: https://readyset.io/docs/reference/features/queries are broken, leads to 404

[altmannmarcelo]

Hi @marco-alban-atomic . Thanks for flagging the documentation issue. We were in the process of updating it.
The link should properly redirect now.

I will check with regard to the CTE support.

[gvsg-rs]

Will readyset ever support multiple CTEs? We get an error saying "Cannot find table" with the name of the CTE

We don't currently support CTEs, but it is on our roadmap.

We tried converting to nested subqueries and we get ""couldn't be added: MIR node '47' couldn't be lowered to dataflow""

We can do better on converting intneral codes into more explainable messages. Thank you for pointing this out. For now, we're happy to explain this. If its not supported, there may be flags we can turn on to enable support for certain queries. Please reach out.

Is there a support channel?

Click on the Slack link on Readyset.io home page. Copying the link below for your convenience.

https://readysetcommunity.slack.com/signup#/domain-signup

We were hoping to be a paying customer but there does not even seem to be an official support email?

Community support is accessible over Slack. Its at the top, and the bottom of our homepage. Thank you for sharing feedback -- we can make this stand out more.

[marco-alban-atomic]

Should have mentioned that I did try the slack link but there is domain validation only for your own domain?

[gvsg-rs]

Oops. Thanks for pointing that out. While we fix the link, please feel free to send us an email to: support@readyset.io I'll invite you to our community slack when you send us a note.