enhancement: use an ORM

## proposal

currently we are using raw sqlite without any ORM, and with time complexity of this method is increasing and its hard to write query for every little thing, and more prone to errors

we should switch to an ORM instead.