/dev-club/b/dev-blog/posts/formatting-sql-queries-from-the-sugarcrm-log-fileEver since prepared queries appeared in Sugar it has made debugging queries a lot more challenging. When you set your log level to INFO and collect the suspect queries you are presented with queries that look like thisSELECT meetings.id, meetin...en-USTelligent Community 12https://sugarclub.sugarcrm.com/dev-club/b/dev-blog/posts/formatting-sql-queries-from-the-sugarcrm-log-fileMon, 25 Jan 2021 18:27:27 GMT5c521d64-519d-47a6-9065-134618b211bf:29792546-99b2-4013-afe1-503db3ddfa39Kenneth Brill0<p>I have been told that the SQL console in JetBrains products will accept SQL with placeholders and then allow you to fill in the params manually.&nbsp; I tried this but many of my queries had long lists of &#39;0&#39;s and &#39;1&#39;s and it was just too difficult to keep straight over and over.&nbsp; But it does work so there is at least 1 way to run the queries outside of this.</p><img src="https://sugarclub.sugarcrm.com/aggbug?PostID=1628&AppID=56&AppType=Weblog&ContentType=0" width="1" height="1">