SQL Logging improvement

[lorefnon]

It would be very helpful if we could log all the SQL parameters (both name and value) alongside the query being executed in one place.

Currently we have one log: Executing query ... that shows the SQL but not parameters, and many Binding value ...in statement ... logs that don't include the parameter name. This makes it a bit hard to debug larger queries with multiple parameters.

What IMHO would be ideal is something like:

[2024-01-09T09:25:26.024Z DEBUG sqlpage::webserver::database::execute_queries] Executing query: "select * from purchase_orders where start_date >= $1 and end_date < $2"
with parameters $1=$start_date="2024-01-01" , $2=$end_date="2024-02-01" 

[lovasoa]

I changed it so that you know get, with RUST_LOG=sqlpage=debug :

[2024-01-09T21:55:03.903Z DEBUG sqlpage::webserver::database::execute_queries] Preparing statement: SELECT 'text' AS component, description AS contents_md FROM example WHERE component = CAST(? AS TEXT) AND properties IS NULL
[2024-01-09T21:55:03.903Z DEBUG sqlpage::webserver::database::execute_queries]  parameter 1: card

and with sqlpage=trace :

[2024-01-09T21:59:46.890Z DEBUG sqlpage::webserver::database::execute_queries] Preparing statement: SELECT 'text' AS component, description AS contents_md FROM example WHERE component = CAST(? AS TEXT) AND properties IS NULL
[2024-01-09T21:59:46.890Z TRACE sqlpage::webserver::database::execute_queries]  evaluating parameter 1: GetOrPost("component")
[2024-01-09T21:59:46.890Z DEBUG sqlpage::webserver::database::execute_queries]  parameter 1: chart
[2024-01-09T21:59:46.890Z TRACE sqlpage::webserver::database::execute_queries] Executing query "SELECT 'text' AS component, description AS contents_md FROM example WHERE component = CAST(? AS TEXT) AND properties IS NULL"

This is still not ideal, but probably more bearable than what we had.

This will be in v0.18. Should be available on docker hub as lovasoa/sqlpage:main in a few minutes.

[lorefnon]

This is great. Thank you.