- var_dump: documentation ( source)
- preg_match_all: documentation ( source)
<?php
$pattern = "/(SELECT|FROM|WHERE|LEFT JOIN|ORDER BY) (.+?)(?= SELECT|FROM|WHERE|LEFT JOIN|ORDER BY|$)/m";
$sql = "SELECT
id,
nome
FROM table as t
WHERE t.id = 123
LEFT JOIN t2 ON t2.id = t.id
ORDER BY t.name
";
preg_match_all($pattern, $sql, $arr);
var_dump($arr);