DOC: expand docs on sql type conversion

Some doc changes related to #8926 and #8973
Should we mention that these can be strings for SQLite types in legacy mode?