Glossary
Microsoft Lists
Microsoft Lists is the app for creating and using SharePoint lists — structured tables of items with typed columns, views, formatting and permissions. It is the same data as a SharePoint list, presented in its own interface.
Lists are where most internal tools should keep their data: they are included in Microsoft 365, everyone can already open one, they carry SharePoint's permission model and they export to Excel.
A useful consequence: any tool built on lists leaves its data behind if the tool goes away. That is the strongest anti-lock-in property available in this stack, and it is worth checking that a vendor actually stores data there rather than in their own database.