Added new "View" collection type allowing you to create a read-only collection from a custom SQL SELECT statement. It supports:

• aggregations (COUNT(), MIN(), MAX(), GROUP BY, etc.)
• column and table aliases
• CTEs and subquery expressions
• auto relation fields association
• file fields proxying (up to 5 linked relations, eg. view1->view2->...->base)
• filter, sort and expand
• List and View API rules

Added auto fail/retry (default to 8 attempts) for the SELECT queries to gracefully handle the database is locked errors (#1795). The default max attempts can be accessed or changed via Dao.MaxLockRetries.

Added default max query execution timeout (30s). The default timeout can be accessed or changed via Dao.ModelQueryTimeout. For the prebuilt executables it can be also changed via the --queryTimeout=10 flag.

Added support for dao.RecordQuery(collection) to scan directly the One() and All() results in *models.Record or []*models.Record without the need of explicit NullStringMap.

Added support to overwrite the default file serve headers if an explicit response header is set.

Added file thumbs when visualizing relation display file fields.

Added "Min select" relation field option.

Enabled process.env in JS migrations to allow accessing os.Environ().

Added UploadedFiles field to the RecordCreateEvent and RecordUpdateEvent event structs.

! Moved file upload after the record persistent to allow setting custom record id safely from the OnModelBeforeCreate hook.

! Changed System.GetFile() to return directly *blob.Reader instead of the io.ReadCloser interface.

! Changed To, Cc and Bcc of mailer.Message to []mail.Address for consistency and to allow multiple recipients and optional name.

If you are sending custom emails, you'll have to replace:

message := &mailer.Message{
  ...

  // (old) To: mail.Address{Address: "to@example.com"}
  To: []mail.Address{{Address: "to@example.com", Name: "Some optional name"}},

  // (old) Cc: []string{"cc@example.com"}
  Cc: []mail.Address{{Address: "cc@example.com", Name: "Some optional name"}},

  // (old) Bcc: []string{"bcc@example.com"}
  Bcc: []mail.Address{{Address: "bcc@example.com", Name: "Some optional name"}},

  ...
}

! Refactored the Authentik integration as a more generic "OpenID Connect" provider (oidc) to support any OIDC provider (Okta, Keycloak, etc.). If you've previously used Authentik, make sure to rename the provider key in your code to oidc. To enable more than one OIDC provider you can use the additional oidc2 and oidc3 provider keys.

! Removed the previously deprecated Dao.Block() and Dao.Continue() helpers in favor of Dao.NonconcurrentDB().

Updated the internal redirects to allow easier subpath deployment when behind a reverse proxy.

Other minor Admin UI improvements.