PHP download

Download the PHP package mysaaspackage/query-builder without Composer

On this page you can find all versions of the php package mysaaspackage/query-builder. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

Table of contents
Download mysaaspackage/query-builder
More information about mysaaspackage/query-builder
Files in mysaaspackage/query-builder

Vendor mysaaspackage
Package query-builder
Short Description Provides a query builder for the database
License MIT

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:

If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.

Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
To use Composer is sometimes complicated. Especially for beginners.
Composer needs much resources. Sometimes they are not available on a simple webspace.
If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.

Please rate this library. Is it a good library?

Example code of mysaaspackage/query-builder

Informations about the package query-builder

QueryBuilder

A fluent SQL query builder for PHP that supports complex queries including CTEs, recursive CTEs, and various SQL operations.

Installation

Basic Usage

SELECT Queries

Common Table Expressions (CTEs)

INSERT, UPDATE, and DELETE Operations

Complex Queries with Subqueries

API Reference

Query Construction Methods

select(...$columns): self - Set columns to select
from(string $table, ?string $alias = null): self - Set the main table
where(string $condition, array $params = []): self - Add a WHERE condition
andWhere(string $condition, array $params = []): self - Add an AND WHERE condition
orWhere(string $condition, array $params = []): self - Add an OR WHERE condition
join(string $table, string $alias, string $condition): self - Add an INNER JOIN
leftJoin(string $table, string $alias, string $condition): self - Add a LEFT JOIN
rightJoin(string $table, string $alias, string $condition): self - Add a RIGHT JOIN
groupBy(string ...$columns): self - Add GROUP BY clauses
having(string $condition, array $params = []): self - Add a HAVING condition
orderBy(string $column, ?string $direction = null): self - Add an ORDER BY clause
limit(int $limit): self - Set the LIMIT
offset(int $offset): self - Set the OFFSET

CTE Methods

with(string $name, QueryBuilder $query, array $columns = [], bool $recursive = false): self - Add a CTE
withRecursive(string $name, QueryBuilder $baseQuery, QueryBuilder $recursiveQuery, array $columns = []): self - Add a recursive CTE

DML Operations

insert(string $table): self - Start an INSERT query
values(array $values): self - Set values for INSERT
update(string $table): self - Start an UPDATE query
set(array $values): self - Set values for UPDATE
delete(string $table): self - Start a DELETE query

Parameter Methods

setParameter(string|int $key, mixed $value): self - Set a parameter value
getParams(): array - Get all parameters

Finalization Methods

toSQL(): string - Get the final SQL query

All versions of query-builder with dependencies

PHP Build Version

Package Version

Version v0.0.1 Release 13. Apr 2025
create-project require 0 people chose require and
0 people chose create-project.

Download

Download latest version of query-builder from vendor mysaaspackage

Requires php Version >=8.1

Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package mysaaspackage/query-builder contains the following files

Loading the files please wait ....