In Bases currently I am unaware of any way to break the 1 File > 1 Entry limitation.
In Dataview this is done with the FLATTEN function. It allows me to essentially duplicate a file within the results of a Table for each instance of a property within that file. For instance, with a Dataview table, I can create a list of both Vice Presidents and Presidents with only the following files that represents both repeated and non-concurrent terms
File: "Donald Trump"
---
Roles:
- Role: "President"
Start: 2025-01-20
- Role: "President"
Start: 2017-01-20
End: 2021-01-20
---
And
File: "Joe Biden"
---
Roles:
- Role: "Vice President"
Start: 2009-01-20
End: 2013-01-20
- Role: "Vice President"
Start: 2013-01-20
End: 2017-01-20
- Role: "President"
Start: 2021-01-20
End: 2025-01-20
---
To accomplish this in Bases, I would have to have multiple stub MD files for each particular “Role” which would be much less workable given larger vault projects.
Also as requested elsewhere, I also would love object support in the frontmatter UI for stuff exactly like this 