Hi @anthonysena ,

we have a fork of this repository available at https://github.com/intersystems-community/OHDSI-WebAPI, but need to first get the one for https://github.com/intersystems-community/OHDSI-DatabaseConnector into the regular OHDSI repository. That work is all ready to submit, but requires that we also make a test server available for OHDSI team members to validate the work. Unfortunately, we're hitting a cluster of red tape internally, with the test server requiring an OS for which our current license provider's contract had to be replaced etc etc :-(
These contracting issues could / should be addressed any day now, so hopefully this won't take much longer.

The repositories referenced above should allow you to get a working version together. If not, please do reach out and we'd be happy to assist!

Thanks,
benjamin

Thanks for this update @bdeboe. In speaking with @alex-odysseus they are working on making the changes to WebAPI and these references will be helpful.

I didn't go through the code but did you have to make changes to support any limit in the IN clause as I mentioned earlier in this issue?

Not sure whether you're asking @alex-odysseus wrt Snowflake, but as far as InterSystems IRIS is concerned we do have a hard limit around 32k, which should be OK given the getParameterLimit() implementation you referenced in #2284 .

Thanks @bdeboe I was asking this of you since @alex-odysseus mentioned they were working on adding the IRIS support and we were unsure of this limit. I think we can treat it the same way we are with Google BigQuery and Snowflake. Thanks!

Martijn, please support in releasing SqlRender 1.19.1 at your convenience which will contain some of the necessary replacement patterns for InterSystems IRIS as we are willing to have the new dialect support in the upcoming WebAPI 2.15.0 release @schuemie

Thank you, Alex

Benjamin, please create pull requests for WebAPI and ATLAS as ARACHNE Commons 1.17.4 should be available @bdeboe

Done. I had not realized the ArachneCommons library was on Maven already, as the GH repo still lists 1.17.3. Thanks for pushing that @alex-odysseus !