query_analysis_routines

SYNOPSIS

Query analysis routines (BETA): routines to parse and analyze query text, including dependency analysis.

DESCRIPTION

These routines parse a given SQL query's text and detect its internal structure and dependencies.

These are not full blown SQL parsers. At the moment the main intent is to be able to realize the objects on which a query depends: tables, views, routines etc.

The queries themselves can be of various types, including:

  • CREATE VIEW statements.
  • CREATE FUNCTION/PROCEDURE statements, including stored routine code within.
  • CREATE EVENT statements, including stored routine code within.

The idea is to be able to quickly realize a dependency graph. For example, to realize the tables/views a view depends on.

Query analysis routines are in BETA stage.


 
common_schema documentation