mo-sql-parsing

mo-sql-parsing copied to clipboard

Hi! Thank you for the previous help! Now I have another problem.. I have SQL like this: ```sql WITH table_test AS ( SELECT public.categories.string_agg AS string_agg FROM public.categories ) SELECT...

twoonefour8

Link back information about position in the original string

4

To analyse SQL in the editor and provide some syntax checking it would be great for each branch or leaf in the tree to know where it starts and ends...

ilyakochik

Feature Request: Functions to extract all tables, columns used by a query

1

A function that could get a query\json repr of a query and output all tables/columns used by a query would be useful for cases in which you want to check...

niroshaimos

Add UDF?

3

* [SQL Server](https://learn.microsoft.com/en-us/sql/relational-databases/user-defined-functions/create-user-defined-functions-database-engine?view=sql-server-ver16) * [MariaDB](https://mariadb.com/kb/en/create-function/) * [BigQuery](https://cloud.google.com/bigquery/docs/reference/standard-sql/user-defined-functions)

klahnakoski

add meta-parser for json output

7

## Overview Dear Lahnakoski, As a part of my PhD thesis, I was very pleased to use your availaible and open-source SQL parser in order to preprocess our SQL queries...

RemilYoucef

Extract tables and joins

1

Requesting adding a feature "table/col relations" adding a function to extract joining tables, join types and join keys. This makes this package wonderful.

mpr1

https://mariadb.com/kb/en/load-data-infile/

klahnakoski

Add select into outfile

1

https://mariadb.com/kb/en/select-into-outfile/

klahnakoski

From issue 119: > Postgres also supports COPY commands with different syntax. > Postgres documentation is here: > https://www.postgresql.org/docs/current/sql-copy.html

klahnakoski

Can we have a api to separate the complex multi-table join query to sub-queries?

4

For a simple join query blow: q = "SELECT Orders.OrderID, Customers.CustomerName FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;" we hope it can separate something similar: "Orders": "SELECT OrderID,...

lenahi