Indeed
Although he shares a name with David and is of small stature hence obvious comparisons, it would appear that Bernardo's future, certainly under Pep, is more likely as part of the front three (playing wide) than the middle three
Given that of our middle three, by and large we play with one more defensively minded midfielders and two more creative/further forward, Foden's future is alongside KDB in front of the DM, basically taking over from David as he plays fewer games due to age
Of course our set up tends to be very fluid and Foden could play further forward just as Bernardo can play further back, but in broad terms, that would appear to be the future.
Some of that depends on the future for Gundogan, on which there appears to be some uncertainty. If he does stay, it's difficult to predict medium term whether he will take on the DM role or be played in addition to a DM thus more directly challenging Foden - Pep has played Gundogan in all areas of midfield. But even then, it's not nearly as congested for top drawer quality as at the front where the six (aguero, jesus, sane, sterling, bernardo & mahrez) are challenging for 3 places