Take a look at the replies by @drsk and @bernhard in this forum post for more explanation on how to think about and work with persistence infrastructure (referred to there as “ledger” or “underlying ledger”).
This is addressed properly in the post I linked, but to put it briefly, a Daml deployment has the properties of the underlying ledger (persistence infrastructure). If you want your ledger to have particular features, you have to choose a persistence infrastructure that has those features; Daml cannot transmute those features to all of its supported drivers.