Change to EXEC statement execution

I have previously used a design pattern for querying some linked DBs which creates a carefully curated prepared statement and then runs the statement using the following steps:

Above, the commented out statement is what would be returned from the geoCodeStatement data.

In previous implementations, this EXEC query would return the table data and any columns I would more specifically define.

Today, however, when implementing this pattern, the returned data was not the table data but just a generic execution response:

image

Older apps which use this pattern are not returning the same response, but the actual table data (example below):

Was there recently an internal change for how executed statements are processed?

Realized the issue was a difference between using a Transformer and a JS query. Using the JS query gives the expected results. Not sure how this is different, but I think this covers my use case!

2 Likes