26 January, 2026

This release expands Keel's expression capabilities with date/timestamp functions in computed fields and adds powerful new filtering with ANY() and ALL() quantifiers.

Date and Timestamp Functions in Computed Fields

You can now use date extraction functions (YEAR, MONTH, DAY, HOUR, MINUTE, SECOND) directly in @computed expressions on Date and Timestamp fields.

This is useful when you need to extract specific components from date fields for reporting, filtering, or display purposes.

model Order {
  fields {
    placedAt Timestamp
    deliveryDate Date
 
    // Extract year and month from timestamps
    orderYear Number @computed(YEAR(order.placedAt))
    orderMonth Number @computed(MONTH(order.placedAt))
 
    // Extract day from dates
    deliveryDay Number @computed(DAY(order.deliveryDate))
  }
}

See the Expressions reference for the complete list of date functions.

ANY() and ALL() Quantifiers for Has-Many Filtering

Filter related records using ANY() and ALL() quantifiers in your @where expressions. This gives you precise control over filtering based on relationships.

Use ANY() when at least one related record must match your condition, and ALL() when every related record must match.

model Customer {
  fields {
    orders Order[]
  }
 
  actions {
    // Find customers who have at least one active order
    list customersWithActiveOrders() {
      @where(ANY(customer.orders.status == OrderStatus.Active))
    }
 
    // Find customers where all orders have been delivered
    list customersAllDelivered() {
      @where(ALL(customer.orders.status == OrderStatus.Delivered))
    }
  }
}

These quantifiers work with all comparison operators and can be combined with other conditions for complex filtering.

External PostgreSQL Support

The Keel CLI now supports connecting to an external PostgreSQL database instead of using Docker. Use the --database-url flag to specify your connection string:

keel run --database-url postgresql://user:pass@localhost:5432/mydb

This is useful when you prefer to manage your own PostgreSQL instance during local development.

Fixes and Improvements

For a full list of fixes and improvements, check out our GitHub releases page (opens in a new tab).

For any issues or feedback, please contact us at help@keel.so.

Thank you for using Keel!