Agree with @drjjwmac: Tap Forms.
I’ve found Airtable to be useful for simple databases where sharing is required, or for collecting survey responses from large numbers of people.
For my main use case of collecting confidential patient information for future reference, Airtable or its competitors are obviously not suitable.
I had written off Tap Forms many times because of the name—after all, I wanted a database and not a form application. When I finally downloaded the trial version I was surprised to see that it was exactly what was after. It’s an attractive, actively-developed mac database app built on top of SQLite that is powerful and flexible. It is very reasonably priced, there is an active forum of users, a single developer who is very responsive, great documentation, optional database encryption, JavaScript support and an iOS app with iCloud syncing. My only regret is that I didn’t discover it years earlier. Probably not as good as Airtable or similar if you need a collaborative database but for my use it’s perfect. Would love to hear more about it on the show. Perhaps even interviewing the developer?