Learning Documentation Community Open Exchange Global Masters Certification Partner Directory Ideas Portal
InterSystems Ideas
We love hearing from our users. Tell us what you want to see next and upvote ideas from the community.
* Bugs and troubleshooting should as usual go through InterSystems support.
Add a new idea Subscribe
Status Implemented
Categories InterSystems IRIS
Created by Evgeny Shvarov
Created on Jan 22, 2022

RELATED IDEAS

Introduce WITH into IRIS SQL engine

Introduce the support of WITH functionality in IRIS SQL

  • ADMIN RESPONSE
    Apr 4, 2024

    Thank you for submitting the idea.

    This idea was implemented by InterSystems.

  • Post comment
  • Wolf Koelling
    Reply
    |     Jan 17, 2024

    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.

    3 replies