Migrate from creating a session with every query to a more efficient transaction structure

References:


https://github.com/Skatetrax/skatetrax_core/pull/4#discussion_r1863728432
https://github.com/Skatetrax/skatetrax_core/pull/4#discussion_r1863734062
https://github.com/Skatetrax/skatetrax_core/pull/4#discussion_r1863736201
