two single quotes inside a string value of a cfscript 'Query' function adds a space between them... 

the code:
var a =new Query("select name from users where last_name = 'o''brian'");
   a.execute();

results in the following query being executed against the database (notice the space between the single quotes):
select name from users where last_name = 'o' 'brian'

As you know, two single quotes inside a literal string is escaped to one single quote in all the RDBMS's I know of.

I tested this the best I can. hopefully this is good enough to be accepted.