refactor aggregate in database_logic #771

Job	Run time
Python 3.8 testing with elasticsearch7	1m 50s
Python 3.8 testing with elasticsearch8	1m 55s
Python 3.8 testing with opensearch	1m 50s
Python 3.9 testing with elasticsearch7	1m 44s
Python 3.9 testing with elasticsearch8	1m 49s
Python 3.9 testing with opensearch	1m 52s
Python 3.10 testing with elasticsearch7	1m 47s
Python 3.10 testing with elasticsearch8	1m 55s
Python 3.10 testing with opensearch	1m 47s
Python 3.11 testing with elasticsearch7	2m 11s
Python 3.11 testing with elasticsearch8	2m 15s
Python 3.11 testing with opensearch	2m 5s
Python 3.12 testing with elasticsearch7	1m 47s
Python 3.12 testing with elasticsearch8	1m 43s
Python 3.12 testing with opensearch	1m 48s
	28m 18s

Provide feedback