Logging: Make it possible to parse params in the query event

[tmtron]

Discussed in #14158

^{Originally posted by tmtron July 5, 2022}
In the query event we get the query which can include ? placeholders and the params which is an array-like string: e.g. [\"abc2\",2022-07-05 14:18:03.680719400 UTC,2]

We'd like to write a convenience function to replace the ? with the actual param values - just for readability of the log-messages during development (It can be quite difficult to understand a long query with multiple parameters)

I tried to write a simple parsing logic for the params, but I think, currently there is no reliable way to parse that string (i.e. to get the individual items), because quotes and commas within a string are not escaped

• e.g. when the first parameter is a "," in a string, and the 2nd parameter is p2 the params array is [\"a \",\" in a string\",\"p2\"]
• from the number of question marks in the query, we know that there must be 2 parameters , but it's not possible to know if these are
  1. a "," in a string and p2
  2. or a " and " in a string","p2"

Notes:

• we use SQLite
• Maybe, there there is already a function to do that?
• Or is there a way to tell prisma to JSON encode the params?

[mhio]

Also #12441