Skip to content

[Proposal]: SQL Parsers - PHP Extension #2032

@norberttech

Description

@norberttech

Describe the Proposal

It would not be anything new when I say that I would love to have a SQL parsers in PHP 😅
And I think I found a solution, https://github.com/pganalyze/libpg_query if we could wrap it as a PHP extension and make it installable through PIE we could unlock whole new set of features like:

  • building entire ETL pipelines from pure SQL SQL Support #1444
  • building DBAL Extractor from raw SQL

and many more.

In order to do that we need to add to monorepo pg-query extension that would expose parse and at leats fingerprinte and maybe split functions to php.

API Adjustments

No response

Are you intending to also work on proposed change?

Yes

Are you interested in sponsoring this change?

None

Integration & Dependencies

We need to add to nix shell all dependencies from https://github.com/pganalyze/libpg_query in order to be able to compile the extension.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Projects

Status

Done

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions