connection API split into get and select for better access