rails3 : ActiveRecord sqlite3 : lost column type when using views

Originally I asked in Stackoverflow until I realized MySQL adapter does work correctly.

Rails 3.0.0.beta3 with ruby 1.9.2head (happens in 2.3.5 / ruby 1.8.7 too)

DATETIME columns in sqlite3 are interpreted as Time/TimeWithZone objects. However, when using a view over a table where the adapter already interprets the time column type correctly, you get a String instead:

    #!/usr/bin/env ruby

    %w|pp rubygems active_record irb active_support date|.each {|lib| require lib}

    ActiveRecord::Base.establish_connection(
    :adapter => "sqlite3",
    :database => "test.db"
    )

    ActiveRecord::Schema.define do
      create_table :people, :force => true do |t|
        t.column :name, :string
        t.column :born_at, :datetime
      end

      execute "create view clowns as select p.name, p.born_at, datetime(p.born_at, '+' || '20' || ' minutes') as     twenty_after_born_at from people p;"

    end

    class Person < ActiveRecord::Base
      validates_presence_of :name
    end

    class Clown < ActiveRecord::Base
    end

    Person.create(:name => "John", :born_at => DateTime.now)

    pp Person.all.first.born_at.class
    pp Clown.all.first.born_at.class
    pp Clown.all.first.twenty_after_born_at.class

Produces output:

Time
Time
String

The same case in MySQL:

    #!/usr/bin/env ruby

    %w|pp rubygems active_record irb active_support date|.each {|lib| require lib}

    ActiveRecord::Base.establish_connection(
        :adapter => "mysql",
        :username => "root",
        :database => "test2"
    )

    ActiveRecord::Schema.define do
      create_table :people, :force => true do |t|
        t.column :name, :string
        t.column :born_at, :datetime
      end

      execute "create view clowns as select p.name, p.born_at, (p.born_at + INTERVAL 20 MINUTE) as twenty_after_born_at from people p;"
    end

    class Person < ActiveRecord::Base
      validates_presence_of :name
    end

    class Clown < ActiveRecord::Base
    end

    Person.create(:name => "John", :born_at => DateTime.now)

    pp Person.all.first.born_at.class
    pp Clown.all.first.born_at.class
    pp Clown.all.first.twenty_after_born_at.class

Produces output:

Time
Time
Time

Which is what I expect.