Ensure Parameters are in proper order for queries having WITH clause

[rubenssoto]

Hello Everyone,

I am having a bug with Presto and Prepare statement.

I run the following prepare statement:

PREPARE statement1 FROM 
with t1 as (select * 
from database.fact_order
join database.dim_poc
on database.dim_poc.poc_id = database.fact_order.poc_id
where "database"."dim_poc"."poc_category" IN (?)
and database.fact_order.poc_id = ?)
select * from t1
where created_date_brt = ?
limit 10

A normal behavior is to have something like that on Execution phase:

EXECUTE statement1 USING 'BAR', 1234, DATE '2021-11-16'

But PrestoDb Expected the wrong order:

EXECUTE statement1 USING DATE '2021-11-16', 'BAR', 1234

This bug is related to the same bug on Trino
trinodb/trino#1191

Trino has a PR to solve the problem:
trinodb/trino#1529

thank you