Extracts
Read from various data sources.
Transforms
Shape and optimize for your needs.
Loads
Store and secure in one of many available data sinks.
Examples:
                            ▶
                            ▼
                            composer.json
                        
                        {
    "name": "flow-php/examples",
    "description": "Flow PHP - Examples",
    "license": "MIT",
    "type": "library",
    "require": {
        "flow-php/etl": "1.x-dev"
    },
    "minimum-stability": "dev"
}code.php<?php
declare(strict_types=1);
use function Flow\ETL\DSL\{data_frame, from_sequence_number, ref, to_stream};
require __DIR__ . '/vendor/autoload.php';
data_frame()
    ->read(from_sequence_number('id', 0, 10))
    ->sortBy(ref('id')->desc())
    ->collect()
    ->write(to_stream(__DIR__ . '/output.txt', truncate: false))
    ->run();
Output
+----+
| id |
+----+
| 10 |
|  9 |
|  8 |
|  7 |
|  6 |
|  5 |
|  4 |
|  3 |
|  2 |
|  1 |
|  0 |
+----+
11 rows