After removing the option 'Escape characters?' running the Sql step results in an error.
Test case
Instance: next
Tenant: Regression Tests
Flow: CB_Sql
Error:
org.apache.camel.ResolveEndpointFailedException: Failed to resolve endpoint: sql-custom://?connectionType=postgres&database=postgres&escapeChars=false&host=api-testing.dovetail.world&password=xxxxxx&port=5432&query=RAW(INSERT into transactions (timestamp,breadcrumb_id,server,tenant,environment,flow_id,flow_name,name,value) VALUES ('2026-09-11 13:17:29','902EE743B367363-000000000000ACD7','https://next.dovetail.world','Regression Tests','test','6a54ce16aa93e3000c0001b5','CB_SQL','name','value'))&tlsVersion=TLSv1&useSSL=false&username=xxxxxx due to: Failed to resolve endpoint: sql-custom://?connectionType=postgres&database=postgres&escapeChars=false&host=api-testing.dovetail.world&password=xxxxxx&port=5432&query=RAW(INSERT%20into%20transactions%20(timestamp,breadcrumb_id,server,tenant,environment,flow_id,flow_name,name,value)%20VALUES%20('2026-09-11%2013:17:29','902EE743B367363-000000000000ACD7','https://next.dovetail.world','Regression%20Tests','test','6a54ce16aa93e3000c0001b5','CB_SQL','name','value'))&tlsVersion=TLSv1&useSSL=false&username=xxxxxx due to: There are 1 parameters that couldn't be set on the endpoint. Check the uri if the parameters are spelt correctly and that they are properties of the endpoint. Unknown parameters=[{escapeChars=false}]
After removing the option 'Escape characters?' running the Sql step results in an error.
Test case
Instance: next
Tenant: Regression Tests
Flow: CB_Sql
Error:
org.apache.camel.ResolveEndpointFailedException: Failed to resolve endpoint: sql-custom://?connectionType=postgres&database=postgres&escapeChars=false&host=api-testing.dovetail.world&password=xxxxxx&port=5432&query=RAW(INSERT into transactions (timestamp,breadcrumb_id,server,tenant,environment,flow_id,flow_name,name,value) VALUES ('2026-09-11 13:17:29','902EE743B367363-000000000000ACD7','https://next.dovetail.world','Regression Tests','test','6a54ce16aa93e3000c0001b5','CB_SQL','name','value'))&tlsVersion=TLSv1&useSSL=false&username=xxxxxx due to: Failed to resolve endpoint: sql-custom://?connectionType=postgres&database=postgres&escapeChars=false&host=api-testing.dovetail.world&password=xxxxxx&port=5432&query=RAW(INSERT%20into%20transactions%20(timestamp,breadcrumb_id,server,tenant,environment,flow_id,flow_name,name,value)%20VALUES%20('2026-09-11%2013:17:29','902EE743B367363-000000000000ACD7','https://next.dovetail.world','Regression%20Tests','test','6a54ce16aa93e3000c0001b5','CB_SQL','name','value'))&tlsVersion=TLSv1&useSSL=false&username=xxxxxx due to: There are 1 parameters that couldn't be set on the endpoint. Check the uri if the parameters are spelt correctly and that they are properties of the endpoint. Unknown parameters=[{escapeChars=false}]