Abstraction Layer for PostgreSQL

[Hemanthr1]

Issue Description

Implement an abstraction layer for PostgreSQL to improve database management and facilitate easier interactions with the database.

Expected Behavior

The application should seamlessly manage database operations through the abstraction layer, enhancing maintainability and flexibility.

Actual Behavior

Currently, the database interactions are tightly coupled with the implementation, making management more complex.

[JishnuGoyal]

Hi, I understand that this is a comparatively complex issue, but i would like to go about it if it can be assigned. I tried searching for PostgreSQL in the codebase, but I found all the repositories in the /repo package extend the mongoRepository.
I wonder which file would be a good starting point to approach this issue. I would also highly appreciate if the issue description could be elaborated a bit, giving more insight into what is expected from the prospective solution.

Thanks!

[Hemanthr1]

@dhairya-quash Help @JishnuGoyal with understanding the issue in detail

[Hemanthr1]

@JishnuGoyal Kindly resume the conversation for any issue on our discord's open-source channel https://discord.gg/BuQPj8JY