DOC: expand docs on sql type conversion

Some doc changes related to #8926 and #8973