.sql

create view tagged as
  select *,
  (
    select rule.tag 
    from rule
    where contains(tx.description, rule.keyword)
    limit 1
  ) as tag
  from tx;