refactor to get rid of dependencies between layers
refactor to move sql scripts into they own files
refactor to move sql scripts into they own files