If you are naming the books like that so they can be easily found / organized on your eReader you should look at two things:
1: Make use of the calibre Series / Series Index fields
2: Make use of a plugboard to rename the book on transfer to your eReader.
See
https://www.mobileread.com/forums/sho...d.php?t=118563 for more info on the plugboards.
With this approach, a book is still called (for instance)
Dune Messiah in calibre. However, it is also flagged as book
2 in the series
Dune.
When the book is sent to the eReader the title of the book will be changed to
Dune - 2 - Dune Messiah. This means it will sort correctly by title with other books in the Dune series.
It also means that the retrieval of metadata will work correctly, in the calibre will look for a book titled
Dune Messiah.