I copy and pasted the content of the SQL Snippets post on this forum and your post into an LLM. Because I'm such a rookie it ended up being to long of a collab to paste here, but I strongly believe it may give you the answer you are looking for. Even code blocks of SQL snippets tailored to your specific use cases.