Nesha asked if it’s possible to view the SQL code behind standard Discourse Dashboard reports to learn and build custom reports. JammyDodger replied that these reports are located in the Discourse GitHub repository under app/models/concerns/reports, though they may be harder to interpret than Data Explorer queries. They also recommended a helpful topic on using Data Explorer’s interactive features and encouraged Nesha to start a new topic if they’re working on specific queries — the community welcomes contributions to expand shared examples.
We love Data Explorer plugin! Already constructed few specific queries to look for sensitive words and phrases.
But we wander is it possible to see the SQL behind standard reports available on Discourse Dashboard? That can enable us to learn a lot and start constructing customised reports
Thanks
I think those ones are found in https://github.com/discourse/discourse/tree/main/app/models/concerns/reports, though may not be as easy to decipher as some of the ones shared in data-explorer topics. 
There are some good tricks in this topic too for some of the Data-Explorer automagic you can leverage to make the results more interactive:
If there are any queries in particular you’re trying to create feel free to spin up a topic and ‘think out loud’, as we’re always looking for more examples we can add to our community pool. 
