Need help with using query variables

[mehanizm]

I'd like to use variable from another query inside jdbc bridge query but do not understand how to do this.

I want to do smth like this:

with max_id as (select max(ID) from table_2)
select
 *

from jdbc('oracle', 'schema', 
   'select
 * from schema.table where id > {{max_id}}');

If it is possible, please, point me to the correct way.

[mehanizm]

I've solved this

select
 *

from jdbc(
    (select concat('oracle?max_id=', toString(max(ID)) from table_2),
    'schema', 
    'select
 * from schema.table where id > {{max_id}}');