#Select

use Formal\AccesLayer\{
    Query\Select,
    Table\Name,
};

$select = Select::from(new Name('users'));
$users = $connection($select);

This will return all the content of the users table.

[!NOTE] if you replace the constructor ::from() by ::onDemand() it will run your query lazily by returning a lazy Sequence, meaning it won't keep the results in memory allowing you to handle very large results.

#Specifying columns to return

use Formal\AccesLayer\{
    Query\Select,
    Table\Name,
    Table\Column,
};

$select = Select::from(new Name('users'))->columns(
    new Column\Name('username'),
    new Column\Name('name'),
);
$users = $connection($select);

#Filter rows

To filter the rows to select this library uses the specification pattern.

use Formal\AccesLayer\{
    Query\Select,
    Table\Name,
    Table\Column,
};
use Innmind\Specification\{
    Comparator,
    Composable,
    Sign,
};

final class Username implements Comparator
{
    use Composable;

    private string $value;

    public function __construct(string $value)
    {
        $this->value = $value;
    }

    public function property(): string
    {
        return 'username'; // this is the name of the column
    }

    public function sign(): Sign
    {
        return Sign::equality;
    }

    public function value(): mixed
    {
        return $this->value;
    }
}

$select = Select::from(new Name('users'))->where(
    (new Username('some username'))->or(new Username('other username')),
);
$users = $connection($select);

[!NOTE] the property name can include the name of the table to match by using the format '{table}.{column}'. The value of the specification can also be a query (this will translated to a sub query).