The API should definitely either allow directly managing indexes or provide even lower level primitives that let the query engine create its own indexes.