i added some custom functions to get the generated sql, but they don't work for lucee, can anyone please guide https://trycf.com/gist/f4df74d2873960062f10241999d21127/lucee5?theme=monokai

Are you facing any error ?

Yes it’s throwing error on internal methods getsql

You can get the sql from the query result ( result="myQOQResult" ) https://trycf.com/gist/ff1f0608e6c2f3abe13c3a8fb97a9ba5/lucee5?theme=monokai

But it does not take into consideration the queryparams

@gsr yer falling back into old habits pal. Come on... articulate the issue clearly, give us the full error, explain what yer trying to do, what troubleshooting have you done, etc? Don't just slap some code down in front of us and go "it no work". Where's your self-contained repro?