module Sequel::SQLite::DatasetMethods

def select(*cols)

get correct column names, you must use an alias.
(including the qualifier) instead of just the column name. To
is a subselect, the column name used is the full qualified name
When a qualified column is selected on SQLite and the qualifier 
def select(*cols)
  if ((f = @opts[:from]) && f.any?{|t| t.is_a?(Dataset) || (t.is_a?(SQL::AliasedExpression) && t.expression.is_a?(Dataset))}) || ((j = @opts[:join]) && j.any?{|t| t.table.is_a?(Dataset)})
    super(*cols.map{|c| alias_qualified_column(c)})
  else
    super
  end
end