Is there a way to attach indexes to built in collections, like Key, in FQLv10? I use AWS SecretsManager to store and rotate Fauna keys, and the code relies on being able to query a custom index to find the key created by the SecretsManager rotation. This uses a field called “token” which is populated in the key’s metadata when creating it.
That’s unfortunate. There might be more use cases besides mine for system collection indexes. I can think of a multi tenancy scenario where one might need to look up a child database based on some metadata. That was easy to implement in FQLv4 as an index could use any collection as a source, system or otherwise.