[PHP] The SQL keywords WITH is not recognized a valid SQL.

[Luuk34]

What happened?

The string is not formatted as SQL

<?php

$sql = "WITH RECURSIVE cte as (
            SELECT 1 as x
            UNION ALL
            SELECT x+1 FROM cte WHERE x<10)
        SELECT * FROM cte;";

When using a string that starts with SELECT then syntax coloring is working, as expected, but with the keyword WITH it stops working.

This bug-report was caused by this (stackoverflow)question: How to make PHP handeling my "WITH CTE as" SQL?

[jfcherng]

and DROP btw. I am used to add DROP for my own.

[deathaxe]

Maybe sync with Python.