fix(sink): derive append only from optimizer when no format declared

fix(sink): derive append only from optimizer when no format declared #18475