fix: Ensure Flight SQL acquires shared lock

fix: Ensure Flight SQL acquires shared lock #14848