Apple sold iMacs for many years that had a completely separate SSD and HDD, and CoreStorage was used to combine them into a single block device which was then partitioned and formatted as HFS+ or APFS.
You could also do this to your own SSD and HDD, though probably only a good idea with internal ones like in a Mac Pro
You could also do this to your own SSD and HDD, though probably only a good idea with internal ones like in a Mac Pro