...

select 'ABC' as col3, id
from testtable a
where a.id = '{sql-query:dataSource=SQLSERVER|table=false}select id FROM testtable WHERE id = 347878201 {sql-query}'

Limitation: This parameter will not have any effect when the SQL query has the "CONCAT" function.

When NOT to use

There are certain cases where your inner query expects value/input from the outer query. In these cases, you should not use this parameter. Please see the sample SQL below:

...

use jiradbnew;
select user_name, directory_id, display_name, email_address, dir.directory_position
from cwd_user usr
join cwd_directory dir on dir."id" = usr."directory_id" and dir."id"= 1

...