Hopefully this can be retired once this can be configured:

rails/rails#50460

* main:
  Fix test
  Allow overriding SQLite defaults from `database.yml` (#50460)
  Fix a flaky test in `query_assertions_test.rb` (#50503)
  Document apply_rubocop_autocorrect_after_generate! in configuration guide (#50532)
  bundle update rubocop --conservative (#50515)

…hancedsqlite3-adapter

Most of the enhancements provided by
activerecord-enhancedsqlite3-adapter have been upstreamed into Rails,
including:

* Add support for generated columns in SQLite3 adapter
  rails/rails#49346
* Add SQLite3 support for supports_insert_returning?
  rails/rails#49290
* Allow overriding SQLite defaults from database.yml
  rails/rails#50460
* Performance tune the SQLite3 adapter connection configuration
  rails/rails#49349
* Allow SQLite3 busy_handler to be configured with simple max number of
  retries rails/rails#49352

One enhancement Joy still needs is a way to load SQLite3 extensions.
There is a sqlpkg gem that would provide this, which includes generating
an initializer that overrides the Rails SQLite3 adapter. Instead, I‘ve
just adapted the enhancedsqlite3-adapter code and droppped into the lib/
directory. The code here also knows how to load an extension by gem name
which is makes it useful for the sqlite_ulid gem currently in use.

…hancedsqlite3-adapter

Most of the enhancements provided by
activerecord-enhancedsqlite3-adapter have been upstreamed into Rails,
including:

* Add support for generated columns in SQLite3 adapter
  rails/rails#49346
* Add SQLite3 support for supports_insert_returning?
  rails/rails#49290
* Allow overriding SQLite defaults from database.yml
  rails/rails#50460
* Performance tune the SQLite3 adapter connection configuration
  rails/rails#49349
* Allow SQLite3 busy_handler to be configured with simple max number of
  retries rails/rails#49352

One enhancement Joy still needs is a way to load SQLite3 extensions.
There is a sqlpkg gem that would provide this, which includes generating
an initializer that overrides the Rails SQLite3 adapter. Instead, I‘ve
just adapted the enhancedsqlite3-adapter code and droppped into the lib/
directory. The code here also knows how to load an extension by gem name
which is makes it useful for the sqlite_ulid gem currently in use.

…hancedsqlite3-adapter

Most of the enhancements provided by
activerecord-enhancedsqlite3-adapter have been upstreamed into Rails,
including:

* Add support for generated columns in SQLite3 adapter
  rails/rails#49346
* Add SQLite3 support for supports_insert_returning?
  rails/rails#49290
* Allow overriding SQLite defaults from database.yml
  rails/rails#50460
* Performance tune the SQLite3 adapter connection configuration
  rails/rails#49349
* Allow SQLite3 busy_handler to be configured with simple max number of
  retries rails/rails#49352

One enhancement Joy still needs is a way to load SQLite3 extensions.
There is a sqlpkg gem that would provide this, which includes generating
an initializer that overrides the Rails SQLite3 adapter. Instead, I‘ve
just adapted the enhancedsqlite3-adapter code and droppped into the lib/
directory. The code here also knows how to load an extension by gem name
which is makes it useful for the sqlite_ulid gem currently in use.

* Allow overriding SQLite defaults from `database.yml`

Any PRAGMA configuration set under the `pragmas` key in the configuration file take precedence over Rails' defaults, and additional PRAGMAs can be set as well.

```yaml
database: storage/development.sqlite3
timeout: 5000
pragmas:
  synchronous: full
  temp_store: memory
```

* Style

* Allow overriding SQLite defaults from `database.yml`

Any PRAGMA configuration set under the `pragmas` key in the configuration file take precedence over Rails' defaults, and additional PRAGMAs can be set as well.

```yaml
database: storage/development.sqlite3
timeout: 5000
pragmas:
  synchronous: full
  temp_store: memory
```

---------

Co-authored-by: David Heinemeier Hansson <david@hey.com>