Maybe it's just me, but I'm surprised that no one has posted the query that works on latest macOS, as it appears that the schema on my machine differs from the author's. The below works on my Monterey machine; you might want to add back the limit 50:

  select
     h.id as sender_name,
     m.text as message_body
  from
     message m
     join handle h on h.rowid = m.handle_id
  order by
     m.date;