Sequel's vritual rows are awesome

activerecord.rb

Movie.select(
  :year,
  "ts_headline(title,   to_tsquery('#{query}'), 'StartSel = <strong>, StopSel = </strong>, HighlightAll = true') AS title",
  "ts_headline(plot,    to_tsquery('#{query}'), 'StartSel = <strong>, StopSel = </strong>, HighlightAll = true') AS plot",
  "ts_headline(episode, to_tsquery('#{query}'), 'StartSel = <strong>, StopSel = </strong>, HighlightAll = true') AS episode"
)

sequel.rb

# It's all Ruby now, so you can use all of the tricks you know :)

Movie.select{[
  year,
  *[:title, :plot, :episode].map do |column|
    ts_headline(
      __send__(column),
      to_tsquery(query),
      "StartSel = <strong>, StopSel = </strong>, HighlightAll = true"
    ).as(column)
  end
]}