vikram0460/sql-elasticsearch-query-converter

Library for converting AND OR SQL like query to Elastic Search query

dev-master 2026-05-27 11:49 UTC

Requires

• php: ^8.2
• ramsey/uuid: ^4.0

proprietary

• Alexander Fedortets
• Vontary Vikram Reddy

README

Converts AND OR SQL like query to Elastic Search query

((("query1 query 2" OR query3) OR query4) AND (query5 OR query6)) AND query7

TO

{"bool":{"must":[{"bool":{"must":[{"bool":{"should":[{"bool":{"should":[{"match_phrase":{"field":"query1 query 2"}},{"match":{"field":"query3"}}]}},{"match":{"field":"query4"}}]}},{"bool":{"should":[{"match":{"field":"query5"}},{"match":{"field":"query6"}}]}}]}},{"match":{"field":"query7"}}]}}

Installation

$ composer require vikram0460/sql-elasticsearch-query-converter:"dev-master"

Usage

Look at examples/example1.php