updated spec for sqlApi