Skip to content

feature: postgresql - condition builder#2113

Merged
norberttech merged 2 commits into1.xfrom
feature/postgresql-condition-builder
Dec 30, 2025
Merged

feature: postgresql - condition builder#2113
norberttech merged 2 commits into1.xfrom
feature/postgresql-condition-builder

Conversation

@norberttech
Copy link
Member

@norberttech norberttech commented Dec 30, 2025

Resolves: #xxx

Change Log

Added

  • postgresql - condition builder fluent interface

Fixed

Changed

Removed

Deprecated

Security

Building conditions upfront is easy, but it's a bit challenging right now to keep adding them.
conditions() : ConditionBuilder is going to make it significantly easier:

$conditions = conditions();

if (array_key_exists('status', $filters)) {
    $conditions = $conditions->and(eq(col('status'), param($filters['status'])));
}

if (array_key_exists('min_age', $filters)) {
    $conditions = $conditions->and(gte(col('age'), param($filters['min_age'])));
}

if (array_key_exists('email_domain', $filters)) {
    $conditions = $conditions->and(like(col('email'), param('%@' . $filters['email_domain'])));
}

$query = select()->from(table('users'));

if (!$conditions->isEmpty()) {
    $query = $query->where($conditions);
}

return $query;

@codecov
Copy link

codecov bot commented Dec 30, 2025 •
edited
Loading

Codecov Report

❌ Patch coverage is 79.31034% with 6 lines in your changes missing coverage. Please review.
✅ Project coverage is 83.00%. Comparing base (817b487) to head (d785587).
⚠️ Report is 3 commits behind head on 1.x.
✅ All tests successful. No failed tests found.

Additional details and impacted files 
@@            Coverage Diff             @@
##              1.x    #2113      +/-   ##
==========================================
+ Coverage   82.75%   83.00%   +0.24%     
==========================================
  Files        1174     1175       +1     
  Lines       41531    41559      +28     
==========================================
+ Hits        34369    34495     +126     
+ Misses       7162     7064      -98
Components Coverage Δ
etl 90.52% <ø> (+0.89%) ⬆️
cli 85.76% <ø> (ø)
lib-array-dot 95.00% <ø> (ø)
lib-azure-sdk 60.01% <ø> (ø)
lib-doctrine-dbal-bulk 95.14% <ø> (ø)
lib-filesystem 80.44% <ø> (ø)
lib-types 88.98% <ø> (+1.51%) ⬆️
lib-parquet 68.25% <ø> (ø)
lib-parquet-viewer 83.04% <ø> (ø)
lib-snappy 90.65% <ø> (+0.93%) ⬆️
bridge-filesystem-async-aws 90.95% <ø> (ø)
bridge-filesystem-azure 89.38% <ø> (ø)
bridge-monolog-http 96.89% <ø> (ø)
bridge-openapi-specification 91.50% <ø> (ø)
symfony-http-foundation 72.32% <ø> (ø)
adapter-chartjs 86.33% <ø> (ø)
adapter-csv 89.30% <ø> (ø)
adapter-doctrine 91.50% <ø> (ø)
adapter-elasticsearch 97.02% <ø> (ø)
adapter-google-sheet 97.05% <ø> (ø)
adapter-http 65.94% <ø> (ø)
adapter-json 89.69% <ø> (ø)
adapter-logger 83.33% <ø> (ø)
adapter-meilisearch 97.77% <ø> (ø)
adapter-parquet 79.92% <ø> (ø)
adapter-text 86.84% <ø> (ø)
adapter-xml 82.66% <ø> (ø)
🚀 New features to boost your workflow:
  • 📦 JS Bundle Analysis: Save yourself from yourself by tracking and limiting bundle sizes in JS merges.

@norberttech norberttech merged commit 1fe36a2 into 1.x Dec 30, 2025
21 of 22 checks passed
@norberttech norberttech deleted the feature/postgresql-condition-builder branch December 30, 2025 19:02
@github-actions
Copy link
Contributor

github-actions bot commented Dec 30, 2025

Flow PHP - Benchmarks

Results of the benchmarks from this PR are compared with the results from 1.x branch.

Extractors 
+--------------------------+--------------------------------+------+-----+-----------------+--------------------+-----------------+
| benchmark                | subject                        | revs | its | mem_peak        | mode               | rstdev          |
+--------------------------+--------------------------------+------+-----+-----------------+--------------------+-----------------+
| CSVExtractorBench        | bench_extract_10k              | 1    | 1   | 5.800mb +0.02%  | 560.923ms +89.16%  | ±0.00% -100.00% |
| DbalExtractorBench       | bench_extract_10k_keyset       | 1    | 1   | 35.111mb +0.04% | 425.976ms +97.80%  | ±0.00% -100.00% |
| DbalExtractorBench       | bench_extract_10k_limit_offset | 1    | 1   | 35.126mb +0.02% | 531.696ms +193.98% | ±0.00% -100.00% |
| ExcelExtractorBench      | bench_extract_10k_ods          | 1    | 1   | 48.752mb +0.00% | 2.015s +120.76%    | ±0.00% -100.00% |
| ExcelExtractorBench      | bench_extract_10k_xlsx         | 1    | 1   | 49.615mb +0.00% | 3.011s +90.31%     | ±0.00% -100.00% |
| JsonExtractorBench       | bench_extract_10k              | 1    | 1   | 6.526mb +0.02%  | 1.719s +57.89%     | ±0.00% -100.00% |
| ParquetExtractorBench    | bench_extract_10k              | 1    | 1   | 11.779mb -0.15% | 14.510s +21.10%    | ±0.00% -100.00% |
| PostgreSqlExtractorBench | bench_extract_10k_cursor       | 1    | 1   | 37.616mb +0.04% | 216.314ms -3.25%   | ±0.00% -100.00% |
| PostgreSqlExtractorBench | bench_extract_10k_keyset       | 1    | 1   | 37.608mb +0.01% | 378.062ms -7.12%   | ±0.00% -100.00% |
| PostgreSqlExtractorBench | bench_extract_10k_limit_offset | 1    | 1   | 37.618mb -0.00% | 338.838ms -6.96%   | ±0.00% -100.00% |
| TextExtractorBench       | bench_extract_10k              | 1    | 1   | 5.800mb +0.02%  | 50.276ms -7.61%    | ±0.00% -100.00% |
| XmlExtractorBench        | bench_extract_10k              | 1    | 1   | 5.819mb +0.02%  | 597.038ms -9.08%   | ±0.00% -100.00% |
+--------------------------+--------------------------------+------+-----+-----------------+--------------------+-----------------+
Transformers 
+---------------------------------+--------------------------+------+-----+------------------+--------------------+-----------------+
| benchmark                       | subject                  | revs | its | mem_peak         | mode               | rstdev          |
+---------------------------------+--------------------------+------+-----+------------------+--------------------+-----------------+
| RenameEntryTransformerBench     | bench_transform_10k_rows | 1    | 1   | 124.672mb +0.00% | 196.057ms +174.69% | ±0.00% -100.00% |
| RenameEachEntryTransformerBench | bench_transform_10k_rows | 1    | 1   | 19.866mb +0.01%  | 145.990ms +105.13% | ±0.00% -100.00% |
+---------------------------------+--------------------------+------+-----+------------------+--------------------+-----------------+
Loaders 
+-----------------------+---------------------+------+-----+------------------+-------------------+-----------------+
| benchmark             | subject             | revs | its | mem_peak         | mode              | rstdev          |
+-----------------------+---------------------+------+-----+------------------+-------------------+-----------------+
| CSVLoaderBench        | bench_load_10k      | 1    | 1   | 47.955mb +0.00%  | 126.945ms +84.12% | ±0.00% -100.00% |
| DbalLoaderBench       | bench_load_10k      | 1    | 1   | 35.117mb -0.01%  | 2.588s +133.40%   | ±0.00% -100.00% |
| ExcelLoaderBench      | bench_load_10k_ods  | 1    | 1   | 6.730mb +0.02%   | 2.843s +90.02%    | ±0.00% -100.00% |
| ExcelLoaderBench      | bench_load_10k_xlsx | 1    | 1   | 11.398mb +0.01%  | 3.958s +69.16%    | ±0.00% -100.00% |
| JsonLoaderBench       | bench_load_10k      | 1    | 1   | 82.786mb +0.00%  | 142.565ms +33.41% | ±0.00% -100.00% |
| ParquetLoaderBench    | bench_load_10k      | 1    | 1   | 794.694mb +0.01% | 16.471s -36.69%   | ±0.00% -100.00% |
| PostgreSqlLoaderBench | bench_load_10k      | 1    | 1   | 37.606mb -0.03%  | 711.102ms -16.48% | ±0.00% -100.00% |
| TextLoaderBench       | bench_load_10k      | 1    | 1   | 19.255mb +0.01%  | 22.457ms -35.35%  | ±0.00% -100.00% |
+-----------------------+---------------------+------+-----+------------------+-------------------+-----------------+
Building Blocks 
+-------------------+----------------------------+------+-----+------------------+--------------------+-----------------+
| benchmark         | subject                    | revs | its | mem_peak         | mode               | rstdev          |
+-------------------+----------------------------+------+-----+------------------+--------------------+-----------------+
| EntryFactoryBench | bench_entry_factory        | 1    | 1   | 107.268mb +0.00% | 1.034s +96.93%     | ±0.00% -100.00% |
| EntryFactoryBench | bench_entry_factory        | 1    | 1   | 56.665mb +0.00%  | 516.954ms +92.54%  | ±0.00% -100.00% |
| EntryFactoryBench | bench_entry_factory        | 1    | 1   | 16.347mb +0.01%  | 102.967ms +73.32%  | ±0.00% -100.00% |
| RowsBench         | bench_chunk_10_on_10k      | 2    | 1   | 95.167mb +0.00%  | 7.808ms +137.52%   | ±0.00% -100.00% |
| RowsBench         | bench_diff_left_1k_on_10k  | 2    | 1   | 112.560mb +0.00% | 518.419ms +113.30% | ±0.00% -100.00% |
| RowsBench         | bench_diff_right_1k_on_10k | 2    | 1   | 95.280mb +0.00%  | 45.993ms +89.23%   | ±0.00% -100.00% |
| RowsBench         | bench_drop_1k_on_10k       | 2    | 1   | 96.042mb +0.00%  | 3.487ms +139.38%   | ±0.00% -100.00% |
| RowsBench         | bench_drop_right_1k_on_10k | 2    | 1   | 96.042mb +0.00%  | 3.477ms +166.25%   | ±0.00% -100.00% |
| RowsBench         | bench_entries_on_10k       | 2    | 1   | 94.202mb +0.00%  | 4.722ms +41.66%    | ±0.00% -100.00% |
| RowsBench         | bench_filter_on_10k        | 2    | 1   | 94.731mb +0.00%  | 27.829ms +65.05%   | ±0.00% -100.00% |
| RowsBench         | bench_find_on_10k          | 2    | 1   | 94.731mb +0.00%  | 28.011ms +69.67%   | ±0.00% -100.00% |
| RowsBench         | bench_find_one_on_10k      | 10   | 1   | 93.420mb +0.00%  | 2.700μs +58.82%    | ±0.00% 0.00%    |
| RowsBench         | bench_first_on_10k         | 10   | 1   | 93.420mb +0.00%  | 0.400μs +33.33%    | ±0.00% 0.00%    |
| RowsBench         | bench_flat_map_on_1k       | 2    | 1   | 102.480mb +0.00% | 28.472ms +93.85%   | ±0.00% -100.00% |
| RowsBench         | bench_map_on_10k           | 2    | 1   | 131.908mb +0.00% | 121.137ms +73.50%  | ±0.00% -100.00% |
| RowsBench         | bench_merge_1k_on_10k      | 2    | 1   | 95.251mb +0.00%  | 2.653ms +108.50%   | ±0.00% -100.00% |
| RowsBench         | bench_partition_by_on_10k  | 2    | 1   | 98.642mb +0.00%  | 111.041ms +82.11%  | ±0.00% -100.00% |
| RowsBench         | bench_remove_on_10k        | 2    | 1   | 96.304mb +0.00%  | 7.512ms +113.37%   | ±0.00% -100.00% |
| RowsBench         | bench_sort_asc_on_1k       | 2    | 1   | 93.804mb +0.00%  | 77.126ms +88.76%   | ±0.00% -100.00% |
| RowsBench         | bench_sort_by_on_1k        | 2    | 1   | 93.805mb +0.00%  | 78.092ms +94.09%   | ±0.00% -100.00% |
| RowsBench         | bench_sort_desc_on_1k      | 2    | 1   | 93.804mb +0.00%  | 78.647ms +89.01%   | ±0.00% -100.00% |
| RowsBench         | bench_sort_entries_on_1k   | 2    | 1   | 95.863mb +0.00%  | 16.506ms +97.16%   | ±0.00% -100.00% |
| RowsBench         | bench_sort_on_1k           | 2    | 1   | 93.613mb +0.00%  | 58.998ms +92.20%   | ±0.00% -100.00% |
| RowsBench         | bench_take_1k_on_10k       | 10   | 1   | 93.420mb +0.00%  | 27.500μs +104.85%  | ±0.00% -100.00% |
| RowsBench         | bench_take_right_1k_on_10k | 10   | 1   | 93.420mb +0.00%  | 27.700μs +77.19%   | ±0.00% -100.00% |
| RowsBench         | bench_unique_on_1k         | 2    | 1   | 112.561mb +0.00% | 425.341ms +73.35%  | ±0.00% -100.00% |
| TypeDetectorBench | bench_type_detector        | 1    | 1   | 43.528mb +0.00%  | 521.447ms +56.59%  | ±0.00% -100.00% |
| TypeDetectorBench | bench_type_detector        | 1    | 1   | 12.585mb +0.01%  | 59.586ms -10.95%   | ±0.00% -100.00% |
+-------------------+----------------------------+------+-----+------------------+--------------------+-----------------+
Parquet Library 
+--------------------+---------------------------------+------+-----+------------------+--------------------+-----------------+
| benchmark          | subject                         | revs | its | mem_peak         | mode               | rstdev          |
+--------------------+---------------------------------+------+-----+------------------+--------------------+-----------------+
| ParquetWriterBench | bench_write_batch               | 1    | 1   | 12.698mb -12.70% | 358.401ms +60.82%  | ±0.00% -100.00% |
| ParquetWriterBench | bench_write_gzip                | 1    | 1   | 11.357mb +0.03%  | 432.399ms +99.70%  | ±0.00% -100.00% |
| ParquetWriterBench | bench_write_row_by_row          | 1    | 1   | 12.698mb -12.70% | 377.589ms +68.28%  | ±0.00% -100.00% |
| ParquetWriterBench | bench_write_snappy              | 1    | 1   | 12.698mb -12.70% | 447.209ms +99.02%  | ±0.00% -100.00% |
| ParquetWriterBench | bench_write_uncompressed        | 1    | 1   | 11.082mb +0.03%  | 436.966ms +128.01% | ±0.00% -100.00% |
| ParquetReaderBench | bench_page_headers              | 1    | 1   | 7.825mb +0.02%   | 3.748s +102.34%    | ±0.00% -100.00% |
| ParquetReaderBench | bench_read_metadata             | 1    | 1   | 6.520mb +0.02%   | 28.795ms +251.48%  | ±0.00% -100.00% |
| ParquetReaderBench | bench_read_schema               | 1    | 1   | 6.520mb +0.02%   | 25.324ms +206.92%  | ±0.00% -100.00% |
| ParquetReaderBench | bench_read_values_all_columns   | 1    | 1   | 10.096mb -0.17%  | 9.024s +16.30%     | ±0.00% -100.00% |
| ParquetReaderBench | bench_read_values_single_column | 1    | 1   | 7.393mb -0.24%   | 379.944ms -15.21%  | ±0.00% -100.00% |
| ParquetReaderBench | bench_read_values_with_limit    | 1    | 1   | 7.920mb -0.38%   | 30.802ms +31.87%   | ±0.00% -100.00% |
+--------------------+---------------------------------+------+-----+------------------+--------------------+-----------------+

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

No reviews

Assignees

No one assigned

Labels

size: L

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

1 participant

@norberttech