Introduced: CF5
Use by specifying <cfquery dbtype="query"...>.
There are a few bugs, such as the query language features are not 100% SQL92-compliant in CF5.
You must fully specify the table names - no aliasing.
You must alias the columns of your result set, even if they are unique.
You cannot use INNER JOIN syntax.