find gists that illustrate patterns

find-gist-patterns.sql

> with filenames as (
 select
   id,
   jsonb_object_keys(files) as name
 from github_my_gist
)
select
 f.name,
 g.files -> f.name ->> 'language' as language,
 g.description as pattern
from filenames f
join github_my_gist g using (id)
where g.description ~ '^PATTERN'
+-----------------------------------------+----------+-----------------------------------------------+
| name                                    | language | pattern                                       |
+-----------------------------------------+----------+-----------------------------------------------+
| find-unused-security-groups.sql         | SQL      | PATTERN: UNION similar things to combine them |
| untagged-ec2-instances-and-keypairs.sql | SQL      | PATTERN: UNION similar things to combine them |
+-----------------------------------------+----------+-----------------------------------------------+