Search Results for "sql query builder jsp"

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.

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.

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 user can select records.

FluentPDO is a PHP library that provides a fluent interface for building SQL queries using PHP’s PDO. It helps developers write clean, readable SQL-like statements in a programmatic way, simplifying interaction with relational databases while retaining full control. FluentPDO is ideal for lightweight PHP applications that need query flexibility without a full ORM.

This is a component to create dinamic database queries from a check list view. You can set a db object (views/tables/etc) to select columns to be shown in the main checklist to build a query based in the check selection. Add dinamic (sql) or static HTML selects to filter results through wheres with few lines. Create dinamic XLSX reports easily (XLSXWritter)