aql::sql

Returns an array with generated information based on the AQL statement.

$aql = " artist { name } artist_album { name as album_name } ";
$r = aql::sql($aql);
print_r($r);
/*
Array
(
    Array
(
    [sql] => SELECT  artist.name as "name", 
             artist_album.name as "album_name", 
             artist.id as "artist_id", 
             artist_album.id as "artist_album_id" 
             FROM artist as artist 
             LEFT JOIN artist_album as artist_album on artist_album.artist_id = artist.id and artist_album.active = 1 
             WHERE  artist.active = 1 
    [sql_count] => SELECT count(*) as count FROM artist as artist LEFT JOIN artist_album as artist_album on  artist_album.artist_id = artist.id and artist_album.active = 1 WHERE  artist.active = 1
    [subs] => 
    [objects] => Array
        (
        )

    [primary_table] => artist
    [left_joined] => Array
        (
            [0] => artist_album
        )

    [fk] => Array
        (
            [artist] => Array
                (
                    [0] => artist_album
                )

        )

)
*/