partial SQL implementation for all tables and all actions to use

throughout the app