MySQL Forums :: Perl :: Net::MySQL

What do you mean by "dynamic"? The methods of Net::MySQL take a string; you could dynamically construct that string.

Note that Perl allows any of these for quoting a literal string:
q{...}
q(...}
'...'

These strings allow interpolation
"SELECT * FROM $table"
qq{SELECT * FROM $table}
qq(SELECT * FROM $table)

There's also "heredocs" that allow or disallow interpolation.