Newly Enrolled

Need to pull two tables, easiest approach?

We are in Business Intelligence.  We need to pull two tables from our tennant. Invoice Items and Subscriptions.  Here is the kicker, we are not Devs.  We looked at ZOQL, Data Query, etc. We are wondering how to start.  We would love a SELECT * FROM InvoiceItems. Same for Subscriptions.  Guess we need to set up .api.  Is there a template two select an entire table that we can use?  Thanks in advance for you help and pointers.