Skip to content

Google Cloud Query Insights Tags (with sqlcommenter) support #8508

@armandoborge

Description

@armandoborge

Problem

I am using Prisma to perform operations over a Google Cloud SQL instance (Postgres) and I've enabled Query Insights in order to monitor CRUD operations. Query Insights provides a way to tag SQL queries using sqlcommenter, tagging SQL queries simplifies application troubleshooting, the information provided by these tags in the queries helps to find which application code is causing performance problems.

Suggested solution

It would need to be added to the Prisma Client API, then transmitted to the Prisma Query Engine and there added to the query in a similar way than sqlcommenter does it.

Additional context

More information about Query Insights:
https://cloud.google.com/sql/docs/postgres/query-insights-overview
https://cloud.google.com/sql/docs/postgres/using-query-insights#adding_tags_to_sql_queries

sqlcommenter:
https://google.github.io/sqlcommenter/

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions