I have a folder of independent
.sql-files that are used by a FastAPI application to request data from the Oracle Database.
Each file includes a variable (e.g.
:plot_fsk) that is later on modified using a function that changes variable in SQL query by means of the
sqlalchemy.sql.text as shown here.
Here is the content of a single
SELECT CONCAT(A_AA88888.AFL, ' m²') AS PLOTAREA FROM DB_UTM.A_AA88888 A_AA88888 WHERE A_AA88888.FSK = :plot_fsk
For my documentation I would like to have the graphic representation of those
.sql-files in a neat and user-friendly schematic manner. Is there any automatic approach to implement this task?
In that visualization I would like to include:
- all the tables names
- all the attributes that are requested in
WHEREwith their original names
- all the relations between tables, like different
ORDER BYcan be neglected
So, the above SQL query will look like:
I have seen some articles but none of them mention a visualization from an individual file (when the entire Database should not considered):
- Complex SQL Query visualizer
- Tool to Visualize SQL Database Schema
- Good tool to visualise database schema?
- 5 Tools to visualize database schemas
- The 11 Best Data Visualization Tools for SQL
- Reverse Snowflake Joins (abbreviated as revj)