Feature: Optional length cap for lists

[mu-arch]

Description

Feature: Optional length cap for lists

It is useful to be able to enforce limits on lists from inside the database to avoid application code from having to make multiple queries to enforce the limit.

Limit type 1: prevent lists that have met the cap from adding new elements

Limit type 2: automatically pop the oldest list item when inserting new items into the list

[ohsayan]

This is a great idea! Like I noted in chat, this is indeed a very generic use-case and we will implement something in place for this. To implement this, we need two changes:

• Changes to the underlying structure and interface: This is to accommodate for the operations to be run
• Changes to the querying API: We'd need a new set of errors, but this can also be an opportunity to use BQL expressions

[ohsayan]

+1. Nominated