'Expression tree is too large' when indexing

[Brendonovich]

Describe the bug

Indexing large locations can cause the following error:

Database Error: Error executing query: Unknown - Error occurred during query execution: ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(SqliteFailure(Error { code: Unknown, extended_code: 1 }, Some("Expression tree is too large (maximum depth 1000)"))), transient: false })

Reproduction

Index large location or something

Expected behavior

Indexing succeeds

Platform and versions

Anything

Stack trace

No response

Additional context

I think this is probably something to do with creating too many db records in one query, will have to check the indexer logic