Bad
book metadata is still bad metadata.
Calibre READS book Metadata
AS SUPPLIED (unless you have chosen to use filename ONLY)
If the Publisher or User, hand edits the fields
I recently has a multi-author book in (Authors}, only show the
first listed Author in {author_sort}
The Metadata Editor (MDE) allows you to make ANY changes. Even absolute nonsense ones

as long as the SYNTAX is correct