Exporting results with INTO

use FQL\Query\FileQuery;
use FQL\Query\Provider;
use FQL\Enum\Operator;

// Using a FileQuery object
$fileQuery = Provider::fromFileQuery('json(./data/products.json).data.products')
    ->select('name', 'price')
    ->where('price', Operator::GREATER_THAN_OR_EQUAL, 300)
    ->execute()
    ->into(new FileQuery('csv(./exports/products.csv)'));

// Using a string shorthand
$fileQuery = Provider::fromFileQuery('json(./data/products.json).data.products')
    ->select('name', 'price')
    ->execute()
    ->into('json(./exports/products.json).root.items');

// Read the written file back using the returned FileQuery
$readBack = Provider::fromFileQuery((string) $fileQuery)
    ->selectAll()
    ->execute();

SELECT name, price
FROM csv(./data/products-utf-8.csv).*
INTO csv(./exports/products.csv)

format(pathToFile).query

use FQL\Query\Provider;

$fileQuery = Provider::fromFileQuery('json(./data/products.json).data.products')
    ->select('name', 'price')
    ->orderBy('price')->asc()
    ->execute()
    ->into('csv(./exports/products.csv)');
// $fileQuery->query is '*'

use FQL\Query\Provider;

$fileQuery = Provider::fromFileQuery('xml(./data/feed.xml).SHOP.SHOPITEM')
    ->select('NAME', 'PRICE')
    ->execute()
    ->into('json(./exports/items.json).root.items');
// $fileQuery->query is 'root.items'

use FQL\Query\Provider;

$fileQuery = Provider::fromFileQuery('csv(./data/products.csv).*')
    ->selectAll()
    ->execute()
    ->into('xml(./exports/products.xml).SHOP.ITEM');
// $fileQuery->query is 'SHOP.ITEM'

use FQL\Query\Provider;

$fileQuery = Provider::fromFileQuery('json(./data/products.json).data.products')
    ->selectAll()
    ->execute()
    ->into('xlsx(./exports/products.xlsx).Sheet1.A1');
// $fileQuery->query is 'Sheet1.A1'

$fileQuery = $results->into('csv(output/report.csv)');

// The returned FileQuery has the effective query applied (e.g. '*' for CSV)
$readBack = \FQL\Query\Provider::fromFileQuery((string) $fileQuery)
    ->selectAll()
    ->execute();