foo.rb

# without unique column names this is what you need to do to make sure the result set has correct values and there
# are no name clashes
DB[:users].
  join_table(:inner, :tasks, user_id: :users__id).
  select(:tasks__id___task_id, :users__id___users_id)

# versus this, if we had unique column names by default
DB[:users].natural_join(:tasks).select(:task_id, :user_id)

Is this Sequel?