Thanks @Quentin_Pradet for sharing your experiences. I do know they successfully migrated from v5 -> v8 about 18 months ago.
I can confirm they're not using the Elasticsearch Python DSL. Production is running on 3 nodes.
@all: here's an example of a function in our codebase, get_document_by_id , the equivalent of SELECT FROM my_table where id = ${id}
I'm seeing several head-scratching things in this code, not the least of which is manually refreshing the index before each query?
This function is called in 46 places in the codebase.