```ruby
require 'do_sqlite3'
require 'dm-do-adapter'

module DataMapper
  module Adapters

    class SqliteAdapter < DataObjectsAdapter

      def initialize(name, options)
        super(name, normalize_options(options))
      end

      # @api private
      def supports_subquery?(query, source_key, target_key, qualify)
        # SQLite3 cannot match a subquery against more than one column
        source_key.size == 1 && target_key.size == 1
      end

      def normalize_options(options)
        # TODO Once do_sqlite3 accepts both a Pathname or a String,
        # normalizing database and path won't be necessary anymore
        db   = (options[:database] || options['database']).to_s
        path = (options[:path    ] || options['path'    ]).to_s

        options.update(:adapter => 'sqlite3', :database => db, :path => path)
      end

    end

    const_added(:SqliteAdapter)

  end
end
```

Store :database or :path keys only once as Symbols
user
```ruby
require 'do_sqlite3'
require 'dm-do-adapter'

module DataMapper
  module Adapters

    class SqliteAdapter < DataObjectsAdapter

      def initialize(name, options)
        super(name, normalize_options(options))
      end

      # @api private
      def supports_subquery?(query, source_key, target_key, qualify)
        # SQLite3 cannot match a subquery against more than one column
        source_key.size == 1 && target_key.size == 1
      end

      def normalize_options(options)
        # TODO Once do_sqlite3 accepts both a Pathname or a String,
        # normalizing database and path won't be necessary anymore
        db   = (options[:database] || options.delete('database')).to_s
        path = (options[:path    ] || options.delete('path')).to_s

        options.update(:adapter => 'sqlite3', :database => db, :path => path)
      end

    end

    const_added(:SqliteAdapter)

  end
end
```
assistant