InterSystems Ideas
Have an idea, suggestion, or something that doesn’t work as expected in InterSystems products or services? Share it here on the InterSystems Ideas Portal.
The Ideas Portal is where community members can propose improvements, report bugs, and help influence the product roadmap across InterSystems products and the overall developer experience. 22% of submitted ideas are implemented by InterSystems or members of the Developer Community.
💡 Ideas and bugs are both welcome, no matter how big or small. You can submit feature requests, usability improvements, workflow suggestions, and bug reports. Whether you’re an experienced expert or just getting started, your fresh perspective is valuable.
🛠️ About bugs and fixes. If you have access to InterSystems WRC, please submit bugs there for immediate action. Bug reports submitted through the Ideas Portal are reviewed and tracked, but do not guarantee immediate resolution.
Start by sharing what could be better - the community and our teams will help take it from there.
May I ask what the exact status of this is now? It has been Planned or In Progress for over a year. Is it in progress or still just at the aspirational stage?
I can of course only speak of my own organisation but I would say that there is not a single SQL developer here who isn't using Common Table Expressions (WITH) and wouldn't expect to have that available in a SQL database.
All our IRIS and Cache developers love the power and flexibility of integrating SQL with objects and globals. But I cannot persuade any SQL developers to accept IRIS just for its sql capabilities with syntax gaps like the above.