All,

Oracle has a feature where you can use quotes inside strings without
need to double them.

Here is a example:
select q'!where name = 'xyz'!' from dual;
Result: where name = 'xyz'

And another one:
select q'{where name = 'xyz'}' from dual;
Result: where name = 'xyz'

When the opening character is "[", "{", "(" or "<", the closing one is
respectively "]", "}", ")" and ">". In other cases, the opening and
closing shall be identical.

The strings really terminates in <close char><quote>, so you can even
use that character inside it.

I propose the same thing for Firebird.

My real intention is beyond that (i.e., it's related to another new
functionality I'm thinking), but the feature is great in general,
especially for usage with EXECUTE STATEMENT.


Adriano