Tips for learning relevant SQL (especially for those familiar with dataview's query language DQL)?

[AnnaKornfeldSimpson]

Primarily a documentation request and secondly a help request. I imagine I am not the only potential user who has more practical familiarity with the community plugin dataview's query language DQL than any of the SQL variants/dialects. Anyone have recommendations for learning the relevant differences in SQL to best make use of this plugin? Could those be documented?

For example:

• LIKE keyword is frequently mentioned in Obsidian forum by dataview users who know SQL but does not exist in DQL. The example in the README here helps a lot to understand how it might be used, would be great to highlight it in such documentation!
• FLATTEN exists in DQL but I don't think it does in SQL.
• SELECT does not exist in DQL

[sytone]

They can be. I have a vault in a separate repot that I hope will be a live playground to help people learn things like this. With the documentation as well as live examples so they can ensure they are not impacting their main vault.

LIKE is used for wildcards, think of it as a contains function. It uses the percentage symbol as the wild card.

Example: description LIKE 'get%' will find all tasks starting with get. description LIKE '%get%' will get all tasks with the word get somewhere in it. description LIKE '%get' gets all tasks where the description ends in get.

You can then get more complex as the underscore _ is a single character wild card.

This link has many examples and I was looking at brining some of this into the documentation and examples.
https://www.w3schools.com/SQL/sql_like.asp