codeowners.sql

with owned_globs as (
  select 
    directory || unnest(regexp_matches(content, '^([^\s]+)\s+@camdencheek)')[1]) as glob,
  from files
  where name = 'CODEOWNERS'
), owned_files as (
  select *
  from files
  where exists (
    select * 
    from owned_globs 
    where glob_matches(files.path, owned_globs.globs)
  )
)
select path
from owned_files
where content ~ 'your search query';