Re:Show HN: Readsql – convert SQL to most human readable format
by azisk1 on Sunday December 27, 2020 @11:38AM
(#25552154)
I understand the wonder, this is not some kind of magic that will help us solve all SQL issues. That's way too hard. This is a development tool that helps write and read SQL code. So simply saves development time by automating the easy stuff, leaving the hard and important stuff for us to deal with. It is different from other formatters that it lints code inside Python strings. For some context, I am a data engineer and I write a lot of SQL code inside Python code (in the future it should support other programming languages as well).
However, the tool might suggest improvements on SQL code in the future
Re:Show HN: Readsql – convert SQL to most human readable format
by simonbarker87 on Sunday December 27, 2020 @01:14PM
(#25552975)
Ok that puts it in context a little bit, if it’s making your life easier then it must be useful to people in the same position and role. I’ve o it ever written SQL in stored procs and one off queries so relied on Redgates SQL Prompt tool (you might want to take a look at what that does for some inspiration)
If you want to make SQL easier to understand then take a look at a 15 year old stored procedure that’s been hacked at by a dozen devs is over 1,000 lines long, has sketchy rollback error protection, uses two CTEs, a pivot, no temp tables and does some xml shenanigans in the middle (I’m being hyperbolic obviously)
This feels like trying to loose weight by trimming your toe nails, you’re technically lighter but not so as it matters.