Hi,
I hope they will fix this "bug" anyway -> the action using the additional database connection is executed outside the transaction -> so it does not use the data changed during the action. To use the data, it must be previously saved in the database -> so the CTE action must be executed on subsequent steps.
I believe there won’t be any changes to this functionality.
According to the help documentation in WEBCON BPS Designer Studio, such queries are not supported due to the way they are wrapped.
Additionally, the official online documentation confirms that the WITH syntax is not supported:
https://docs.webcon.com/docs/2025R2/Studio/ConnectionsAndDataSource/DataSources/DataSource_MSSQL#12-sql-query
It appears that the fact it worked previously was more of a feature, and in future versions, even potential workarounds may no longer be effective.