Director of Rugby Pat Lam was left to rue missed opportunities as Sale Sharks snatched a late victory at Ashton Gate.