Pretty print db queries

Created on 2 December 2013, over 11 years ago

Updated 7 March 2025, 2 months ago

Devel has a method dpq() to print database queries for debug output.
It is currently being worked on to produce a nicely formatted, more readable output.
#2088593: Add nicedpq() into Devel →
The code ideas are coming from a module, https://drupal.org/project/nicedpq. The module page also has an example how the output will look like.

This is all nice, but it has a flaw: It abuses inheritance to access protected properties of Database\Query\Select and Condition.

This would not be necessary, if Select and Condition had native support for pretty formatted output.
In addition to __toString(), there could be toPrettyString(), that would return formatted output with nice indentation, and placeholders replaced by values.

✨ Feature request

Status

Postponed: needs info

Version

11.0 🔥

Component

database system

Created by

🇩🇪Germany donquixote

Live updates comments and jobs are added and updated live.

stale-issue-cleanup
To track issues in the developing policy for closing stale issues, [Policy, no patch] closing older issues

Incomplete comments

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Comment 2 months ago →
🇺🇸United States smustgrave
Thank you for sharing your idea for improving Drupal.

We are working to decide if this proposal meets the Criteria for evaluating proposed changes. There hasn't been any discussion here for over 8 years which suggests that this has either been implemented or there is no community support. Your thoughts on this will allow a decision to be made.

Since we need more information to move forward with this issue, the status is now Postponed (maintainer needs more info). If we don't receive additional information to help with the issue, it may be closed after three months.

Thanks!

contrib.social Blog FAQ Discussions

Production build 0.71.5 2024