Search Results for "php mysql query builder"
Sort By:
Showing 149 open source projects for "php mysql query builder"
View related business solutions-
AI-generated apps that pass security reviewRetool lets you generate dashboards, admin panels, and workflows directly on your data. Type something like “Build me a revenue dashboard on my Stripe data” and get a working app with security, permissions, and compliance built in from day one. Whether on our cloud or self-hosted, create the internal software your team needs without compromising enterprise standards or control.
-
Enterprise-grade ITSM, for every businessFreshservice is an intuitive, AI-powered platform that helps IT, operations, and business teams deliver exceptional service without the usual complexity. Automate repetitive tasks, resolve issues faster, and provide seamless support across the organization. From managing incidents and assets to driving smarter decisions, Freshservice makes it easy to stay efficient and scale with confidence.
-
1
Laravel Query Builder
Easily build Eloquent queries from API requests
This package allows you to filter, sort and include eloquent relations based on a request. The QueryBuilder used in this package extends Laravel's default Eloquent builder. This means all your favorite methods and macros are still available. Query parameter names follow the JSON API specification as closely as possible. The filter query parameters can be used to add where clauses to your Eloquent query. Out of the box we support filtering results by partial attribute value, exact attribute... -
2
elasticsearc-php
PHP low-level client for Elasticsearch
Introducing Elasticsearch DSL library to provide objective query builder for Elasticsearch bundle and elasticsearch-php client. You can easily build any Elasticsearch query and transform it to an array. This agnostic package is a lightweight wrapper on top of the Elasticsearch PHP client. Its main goal is to allow for easier structuring of queries and indices in your application. It does not want to hide or replace the functionality of the Elasticsearch PHP client. ... -
3
Jet Database
Type safe SQL builder with code generation and automatic query result
Jet is a complete solution for efficient and high-performance database access, consisting of a type-safe SQL builder with code generation and automatic query result data mapping. Jet currently supports PostgreSQL, MySQL, CockroachDB, MariaDB, and SQLite. Future releases will add support for additional databases. -
4
atk4/data
Data Access PHP Framework for SQL & high-latency databases
ATK Data is a data persistence and modeling framework for PHP, developed as part of the Agile Toolkit. It provides a high-level abstraction for working with databases, making it easier to define and manipulate data models with minimal boilerplate code. It supports various SQL and NoSQL databases and integrates seamlessly with Agile UI and other PHP frameworks. -
Ship AI Apps Faster with Vertex AIShip AI apps and features faster with Vertex AI—your end-to-end AI platform. Access Gemini 3 and 200+ foundation models, fine-tune for your needs, and deploy with enterprise-grade MLOps. Build chatbots, agents, or custom models. New customers get $300 in free credit.
-
5
SeaQuery
A dynamic SQL query builder for MySQL, Postgres and SQLite
SeaQuery is a query builder to help you construct dynamic SQL queries in Rust. You can construct expressions, queries and schema as abstract syntax trees using an ergonomic API. We support MySQL, Postgres and SQLite behind a common interface that aligns their behavior where appropriate. -
6
Kysely SQL
A type-safe TypeScript SQL query builder
Kysely is a type-safe TypeScript SQL query builder that provides an intuitive and autocompletion-friendly API. It allows developers to construct complex SQL queries with full type safety, reducing runtime errors and improving code maintainability. Kysely supports various SQL dialects and is compatible with Node.js, Deno, and browser environments. -
7
Laravel JSON API Paginate
A paginator that plays nice with the JSON API spec
In a vanilla Laravel application, the query builder paginators will listen to the page request parameters. This works great, but it does not follow the example solution of the json: API spec. That example expects the query builder paginator to listen to the page[number] and page[size] request parameters. This package adds a jsonPaginate method to the Eloquent query builder that listens to those parameters and adds the pagination links the spec requires. -
8
SqlKata QueryBuilder
SQL query builder, written in c#, helps you build complex queries
SqlKata is a powerful and elegant SQL query builder for .NET that provides a fluent, expressive syntax to construct complex SQL queries programmatically. It supports multiple database engines and can compile queries to raw SQL with parameters, making it easy to integrate with Dapper or ADO.NET. SqlKata emphasizes flexibility and readability, enabling developers to write maintainable and reusable query logic. -
9
Doctrine JSON Functions
Doctrine DQL functions for SQL JSON data type
DoctrineJsonFunctions is a library that adds native support for JSON-related SQL functions to Doctrine ORM. It extends Doctrine’s DQL capabilities to handle PostgreSQL, MySQL, and SQLite JSON functions, enabling developers to write expressive queries involving JSON fields directly in DQL. This is especially useful for applications that store semi-structured data in relational databases. -
Cut Data Warehouse Costs up to 54% with BigQueryBigQuery delivers up to 54% lower TCO than cloud alternatives. Migrate from legacy or competing warehouses using free BigQuery Migration Service with automated SQL translation. Get serverless scale with no infrastructure to manage, compressed storage, and flexible pricing—pay per query or commit for deeper discounts. New customers get $300 in free credit.
-
10
REL
Modern ORM for Golang
REL is a modern and lightweight ORM for Go that emphasizes testability, flexibility, and composability. It supports a repository pattern and expressive query building with support for advanced SQL features. REL aims to make it easier to write maintainable, testable, and readable database logic in idiomatic Go. -
11
Laravel MongoDB
MongoDB based eloquent model and Query builder for Laravel
This package adds functionalities to the Eloquent model and Query builder for MongoDB, using the original Laravel API. This library extends the original Laravel classes, so it uses exactly the same methods. Make sure you have the MongoDB PHP driver installed. In case your Laravel version does NOT autoload the packages, add the service provider to config/app.php. For usage with Lumen, add the service provider in bootstrap/app.php. -
12
Kysely
A type-safe typescript SQL query builder
Kysely (pronounce “Key-Seh-Lee”) is a type-safe and autocompletion-friendly typescript SQL query builder. Inspired by knex. Mainly developed for node.js but also runs on deno and in the browser. Kysely makes sure you only refer to tables and columns that are visible to the part of the query you're writing. The result type only has the selected columns with correct types and aliases. As an added bonus you get autocompletion for all that stuff. As shown in the gif above, through the pure magic... -
13
Prisma
Next-generation ORM for Node.js and TypeScript
Prisma helps app developers build faster and make fewer errors with an open source ORM for PostgreSQL, MySQL and SQLite. Central to Prisma is the schema, a declarative way to define your app's data models and their relations that's human-readable. And you don't have to painstakingly create it from scratch if you already have a database - prisma introspect takes care of that. Prisma Client is a query builder that composes the way you think and gets auto-generated from the Prisma schema with types tailored to your app. ... -
14
jQuery DataTables API for Laravel
jQuery DataTables API for Laravel
This package is created to handle server-side works of DataTables jQuery Plugin via AJAX option by using Eloquent ORM, Fluent Query Builder or Collection. To enable debugging mode, just set APP_DEBUG=true and the package will include the queries and inputs used when processing the table. Please avoid using php artisan serve when developing with the package. There are known bugs when using this where Laravel randomly returns a redirect and 401 (Unauthorized) if the route requires authentication and a 404 NotFoundHttpException on valid routes. -
15
Chartbrew
Open-source web platform used to create live reporting dashboards
Chartbrew is an open-source web application that can connect directly to databases and APIs and use the data to create beautiful charts. It features a chart builder, editable dashboards, embeddable charts, query & requests editor, and team capabilities. It is recommended you head over to the more detailed documentation to find out how to set up Chartbrew. The CLI tool creates a chartbrew/.env file which you can configure at any time if you want to change the database, API & client host, etc. ... -
16
Knex
A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, etc.
Knex.js is a flexible and portable SQL query builder for JavaScript. It supports multiple database systems, including PostgreSQL, MySQL, SQLite3, and more. Knex.js offers a powerful and intuitive API for building and executing SQL queries, making it a popular choice for Node.js applications requiring database interactions. -
17
SQL Formatter
A whitespace formatter for different query languages
SQL Formatter is a JavaScript library for pretty-printing SQL queries. It started as a port of a PHP Library, but has since considerably diverged. It supports various SQL dialects: GCP BigQuery, IBM DB2, Apache Hive, MariaDB, MySQL, Couchbase N1QL, Oracle PL/SQL, PostgreSQL, Amazon Redshift, SingleStoreDB, Snowflake, Spark, SQL Server Transact-SQL, Trino/Presto. See language option docs for more details. The CLI tool will be installed under sql-formatter and may be invoked via npx... -
18
goqu
SQL builder and query library for golang
SQL builder and query library for golang. goqu is an expressive SQL builder and executor. Query builder, parameter interpolation (e.g SELECT * FROM "items" WHERE "id" = ? -> SELECT * FROM "items" WHERE "id" = 1). Built from the ground up with multiple dialects in mind. Insert, multi insert, update, and delete support. Scanning of rows to struct[s] or primitive value[s]. -
19
manticoresearch
Easy to use open source fast database for search
Manticore Search is an easy to use open source fast database for search. Modern MPP architecture and smart query parallelization capabilities allow to fully utilize all your CPU cores to lower response time as much as possible, when needed. Powerful and fast full-text searching which works fine for small and big datasets. Columnar storage support via the Manticore Columnar Library for bigger datasets (much bigger than can fit in RAM). SQL-first: Manticore's native syntax is SQL. It speaks... -
20
Doctrine JSON ODM
An object document mapper for Doctrine ORM using JSON
...It works with JSON and JSONB columns of PostgreSQL (>= 9.4) and the JSON column type of MySQL. -
21
Rukovoditel - Project Management/CRM
Free web-based open-source project management application
Rukovoditel is a free web-based open-source project management application. A far cry from traditional applications, Rukovoditel gives users a broader and extensive approach to project management. Its customization options allow users to create additional entities, modify and specify the relationship between them, and generate the necessary reports. The platform enables users to craft their own application that is specifically tailored for their activity (CRM, ERP, HRM, WMS,... -
22
Livewire Datatables
Advanced datatables using Laravel, Livewire, Tailwind CSS and Alpine
Advanced data tables using Laravel, Livewire, Tailwind CSS, and Alpine JS. It is possible to take full control over your table, you can define a builder method using whatever query you like, using your own joins, groups, etc., and then name your columns using your normal SQL syntax. If you want to give your users the ability to pin specific records to be able to, for example, compare them with each other, you can use the CanPinRecords trait. Ensure to have at least one Checkbox Column so the... -
23
e107
e107 Bootstrap CMS (Content Management System) v2 with PHP, MySQL
e107 is a free and open-source content management system (CMS) that allows you to manage and publish your content online with ease. Developers can save time in building websites and powerful online applications. Users can avoid programming completely! Blogs, websites, intranets – e107 does it all. Make blog posts and static pages for your site with the click of a button. A forum that allows you to have multiple discussion areas on your website. Sub-category areas too. Offer thousands of... -
24
pH7 Social Dating CMS (pH7Builder)❤️
🚀 Professional Social Dating Web App Builder (formerly pH7CMS)
pH7Builder is a Professional, Free & Open Source PHP Social Dating Builder Software (primarily designed for developers ...). This Social Dating Web App is fully coded in object-oriented PHP (OOP) with the MVC pattern (Model-View-Controller). It is low resource-intensive, extremely powerful and highly secure. pH7Builder is included with over 42 native modules and is based on its homemade pH7 Framework which includes more than 52 packages To summarize, pH7Builder Social Dating Script... -
25
EveryDataStoreBackend
EveryDataStoreBackend is the backend engine of the EveryDataStore ECM.
EveryDataStoreBackend is the backend core of the EveryDataStore Enterprise Content Management (ECM) platform. Built with the open-source PHP framework SilverStripe 5, it powers the business logic and defines all core processes behind the scenes. This includes role-based access control, digital record management, workflow processing, and data validation. The backend communicates securely with the Angular-based frontend through the integrated RESTful interface, EveryRESTfulAPI, which...
