pglast
pglast copied to clipboard
lelit
PostgreSQL Languages AST and statements prettifier: master branch covers PG10, v2 branch covers PG12, v3 covers PG13, v4 covers PG14, v5 covers PG15, v6 covers PG16
Hi there! Is there a best practice to visualize this format of AST? Thank you!
This is an issue to track the work required to add full PG 14 support to pglast. This work would be blocked by https://github.com/pganalyze/libpg_query/issues/127.
Hello! Nice projection! Trying to determine if this library could be utilized to parse many SQL statements to form an AST of a schema - or at least have the...
If you create an AST with a column like: ```python ColumnDef( 'column_name', inhcount=0, is_from_type=False, is_local=True, is_not_null=False, typeName=TypeName( names=(String('char'),), pct_type=False, setof=False, typemod=-1, typmods=(A_Const(10),) ) ) ``` it will serialize to `"char"(20)`...
The proxy has been there since the beginning, because in v1 it dealt with the `JSON` structure returned by libpg_query's `parse_sql()` function. Now that there is a set of concrete...
Windows 10, Python 3.6. Full output is: ``` C:\Python36-32\Scripts>python -m pip install pg_query Collecting pg_query Using cached pg_query-0.27.tar.gz Ignoring aenum: markers 'python_version < "3.6"' don't match your environment Requirement already...
Bumps [pypa/cibuildwheel](https://github.com/pypa/cibuildwheel) from 2.16.5 to 2.17.0. Release notes Sourced from pypa/cibuildwheel's releases. v2.17.0 🌟 Adds the ability to inherit configuration in TOML overrides. This makes certain configurations much simpler. If...
![dependabot[bot] avatar](https://avatars.githubusercontent.com/in/29110?v=4 "dependabot[bot] avatar"){kind=avatar}
Bumps [codecov/codecov-action](https://github.com/codecov/codecov-action) from 3 to 4. Release notes Sourced from codecov/codecov-action's releases. v4.0.0 v4 of the Codecov Action uses the CLI as the underlying upload. The CLI has helped to...
Hi @lelit , Not sure if this was already implemented, but it would be great if something like statement type can also be implemented like `query = 'insert into table_1...
Query ``` query = """ CREATE OR REPLACE FUNCTION update_customer_total_sales(customer_id INT) RETURNS VOID AS $$ DECLARE total NUMERIC; BEGIN -- Calculate the total sales for the specified customer SELECT COALESCE(SUM(amount),...
