{"repo":"ScientaNL/DoctrineJsonFunctions","free":true,"listed":false,"github":"https://github.com/ScientaNL/DoctrineJsonFunctions","clone":"git clone https://github.com/ScientaNL/DoctrineJsonFunctions.git","description":"Doctrine DQL functions for SQL JSON data type","language":"PHP","stars":589,"topics":["dql-functions","doctrine","json-operators","mysql","postgresql","mariadb","doctrine-bundle","json-functions","orm","sqlite"],"license":"MIT","category":"databases-storage","readme_excerpt":"DoctrineJsonFunctions A set of extensions to Doctrine ORM that add support for JSON functions in DQL (Doctrine Query Language). Supports MySQL, MariaDB, PostgreSQL, SQLite, and SQL Server. Overview Doctrine ORM does not natively support database-specific JSON functions in DQL. This library bridges that gap by registering custom DQL function nodes for each supported platform. Each function validates at SQL generation time that the correct database platform is in use, so you get an early error if a function is used against the wrong database. Supported Platforms and Functions Database Functions ---------- ----------- MySQL 5.7+ / MariaDB JSON ARRAY , JSON ARRAY APPEND , JSON ARRAY INSERT , JSON ARRAYAGG , JSON CONTAINS , JSON CONTAINS PATH , JSON DEPTH , JSON EXTRACT , JSON INSERT , JSON KEYS , JSON LENGTH , JSON MERGE , JSON MERGE PATCH , JSON MERGE PRESERVE , JSON OBJECT , JSON OBJECTAGG , JSON OVERLAPS , JSON PRETTY , JSON QUOTE , JSON REMOVE , JSON REPLACE , JSON SEARCH , JSON SET , JSON TYPE , JSON UNQUOTE , JSON VALID MySQL 8.0.21+ only JSON VALUE MariaDB only JSON COMPACT , JSON DETAILED , JSON EQUALS , JSON EXISTS , JSON LOOSE , JSON NORMALIZE , JSON QUERY , JSON VALUE PostgreSQL 9.3+ JSONB CONTAINS , JSONB EXISTS , JSONB EXISTS ALL , JSONB EXISTS ANY , JSONB INSERT , JSONB IS CONTAINED , JSON EXTRACT PATH , JSON GET , JSON GET PATH , JSON GET PATH TEXT , JSON GET TEXT SQLite (json1 ext.) JSON , JSON ARRAY , JSON ARRAY LENGTH , JSON EXTRACT , JSON GROUP ARRAY , JSON GRO","default_branch":null,"files":null,"tree":[],"storefront":"/r/ScientaNL","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ScientaNL/DoctrineJsonFunctions/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}