Viewing SQL generated by a Snap

Is there a way I can view the exact SQL that is generated by a pipeline? I am debugging a pipeline that uses the Oracle - Execute snap. The results from the generated SQL are not what I am expected and I would like to be able to see what statement is being run, so I can fix my mistakes

Thank you in advance
Dan

Hi Dan,
Usually I use a mapper before the SQL snap to construct the query and put it in a $sql_query field. Change the SQL snap to use $sql_query. That way, I can grab it during preview and use it directly against the database.
Hope that helps,
Judy