can php adodb do Common Table Expressions?

I'm using the adodb php library (http://phplens.com/adodb/) to connect to sql server 2005, can Common Table Expressions be used in the execute m开发者_JAVA百科ethod?

As long as the SQL is passed through without modifications (which I assume it does) you'll be able to use CTEs, yes.

A simple test could be something like this:

WITH cte AS (
    SELECT * FROM mytable
)
SELECT * FROM cte;