phase 1 implementation of SQL proxy with associations