Add support for partial indexes

[jewzaam]

https://docs.mongodb.com/manual/core/index-partial/

Beyond being a nice capability, we could leverage for unique indexes. Today we have all unique indexes configured to be sparse, else two null index field values would be a collision.

[jewzaam]

Did not create an issue for the related work necessary in core if we do this.