Basic (ELI5) Question about Queries in Amplify Studio

Sorry, I'm not a dev or coder by any means, but I am trying to "professionalize" the application I developed using no code. I was able to recreate my Schema within Amplify studio but I'm struggling with a basic coding concept:

In Airtable and in Access (what I'm used to), you can make fields that are essentially queries of a DB. Each data from the table is in view the DB will query and populate that field to represent the most recent data. In airtable, they're called calculated fields. In developing the Amplify Studio Schema I found there were no "Calculated fields" and no visual way to build queries and integrate them into the system.

So my question is this: if I wanted a persistent query for a table, or to display visually on my app, where would I input it during my development? e.g. The number of comments for a post given a relationship of Many comments for every One Post.

• is it connected to the UI by React-native code in Amplify Studio?
• Is it a function in AWS Lambda (Node.js) that is constantly triggered and then updates DynamoDB?
• Is it a Datastore code filled out in AWS CLI?
• Is there a visual editor within Amplify Studio for "Calculated Fields" and Functions?

Please walk me through it.