pre-work to patch query to support associations