Also, reducing your problem down to a minimal reproducible example, along with some sample data (and ideally a http://sqlfiddle.com/ or https://dbfiddle.uk/ link) will get you much better answers. Source: about 1 year ago

Http://dbfiddle.uk has an AdventureWorks test DB that you could use. Source: about 1 year ago

If you used https://dbfiddle.uk to create a table, load it up with a minimum set of representative rows, then created a minimal, yet representative "first query" and then mocked up what you want your "second query"'s output to look like based on the example data, it might be way easier to comprehend what you are talking about. Source: over 1 year ago

Put it in a fiddle, like dbfiddle.uk or sqlfiddle.com. Source: over 1 year ago

I don't mean to take anything away from this post - its quite amazing and I can't wait to play with it more - but wanted to mention that there are sites out there that I believe solve the training portion maybe a little bit better, at least if all you want is to train on SQL not DBA type actions. My favorite is https://dbfiddle.uk/ - the ability to link and fork a set of statements is extremely handy. - Source: Hacker News / over 1 year ago

Check out https://dbdiagram.io/home, they have a very cool product. You can write ERD as code and ship to DDL language on the fly. Source: about 1 year ago

I like https://dbdiagram.io/home because I can run it open source using Python. Source: over 1 year ago

This combined with DBDiagram.io in a package similar to SSMS, SQLYog, or TablesPlus would be amazing. Source: over 1 year ago

Great work! Been excited to see some work being done in this domain. Just tagging on to the post to ask what is the best diagram type/tool for high-level abstract domain modelling? I find the UML examples quite unwieldy and esoteric. I like the speed of https://dbdiagram.io/home but it's unnecessarily tailored to databases. Source: over 1 year ago

This doesn't seem too complicated in the scope of our simple cookbook but can get very complicated very quickly as the application grows. Thankfully there are tools to help you create diagrams and visualize all of these connections such as: dbdiagram and Figma. - Source: dev.to / over 1 year ago