Shopware Query Builder

by Algoritma Srl

Rating: no rating ( write a review )

Downloads: <10

A modern, fluent query builder for Shopware 6.7+ with zero configuration. Write intuitive SQL-like queries with automatic validation, alias support, and type safety for cleaner code.

Free

Compatible with:

6.7.0.0 - 6.7.12.2

Includes:

All updates

During the subscription all released updates are included for free

Description

Highlights

Comprehensive Alias Support - Clear, linear queries even with complex multi-level associations
Parameter Binding - Secure, reusable queries with named parameters
Advanced Aggregations - Built-in COUNT, SUM, AVG, MIN, MAX support
Nested Query Groups - Infinite AND/OR nesting with intuitive syntax
Reusable Scopes - Encapsulate and share query logic across your application

Features

Alias System - Assign and use aliases for entities and associations
Linear Associations - Register associations with with() and reference via aliases
Compound Expressions - Automatic grouping for AND/OR in WHERE clauses
Comparison Operators - Full support: =, !=, >, <, >=, <=, LIKE
Parameter Binding - Named parameters with setParameter() and setParameters()

Conditional Updates - Update entities matching WHERE conditions
Return Updated Entities - Get entity objects with updated data
Reusable Scopes - Apply query logic via ScopeInterface implementations
Scope Chaining - Apply multiple scopes with scopes() method
Soft Deletes - withTrashed(), onlyTrashed(), withoutTrashed()
Nested Groups - Infinite nesting of condition groups
Association Callbacks - Complex filtering within associations
Custom Sorting - orderBy() with ASC/DESC
Pagination - paginate() with formatted output
Limit/Offset - Standard result limiting

Show more Show less

About the Extension

The Shopware Query Builder is a revolutionary fluent API library designed specifically for Shopware 6.7+, bringing the elegance and simplicity of modern query builders to the Shopware ecosystem. Say goodbye to verbose Criteria construction and hello to intuitive, SQL-like queries that feel natural and read like plain English.

Details

Available: English, German
Latest update: 23 July 2026
Publication date: 18 March 2026
Version: 1.0.0
Category: Administration

Resources

Reviews (0)

Write a review

If you downloaded this extension you can write a review in the Shopware Account.

Write a review

No reviews found.

About the Extension Partner

Algoritma Srl

See all extensions

Partner Status

Shopware
Silver Partner
Shopware
Extension Partner

Details

Partner since: 2023
Extensions: 1
Certifications: 5

Support

Based in: Italy
Speaks: German, English
Response time: Very quickly

Shopware 6 certified