Server side processing question

jakep

Hi

I noticed that in Editor there is a nice way to do complex SQL queries:

Editor::inst( $db, 'users' )
    ->field(
        Field::inst( 'users.first_name' ),
        Field::inst( 'users.last_name' ),
        Field::inst( 'users.phone' ),
        Field::inst( 'users.site' )
            ->options( 'sites', 'id', 'name' ),
        Field::inst( 'sites.name' )
    )
    ->leftJoin( 'sites', 'sites.id', '=', 'users.site' )
    ->process($_POST)
    ->json();

Is there a similar thing to write queries in normal DataTables?

Cheers,
Jake