Couple things to address here. Firstly, for the analysis piece, GraphQL is a query language that translates into SQL when fetching your data. It handles the relationships piece as well, so you don’t have to worry about writing complex SQL statements with joins and what not. Based on your data schema (as you define it), 8base is generating all the GraphQL operations you need.
If you hop into the API Explorer in your management console, or use a too like GraphiQL, and can immediately start interacting with your data.
If you are interested in actually generating SQL Views, you can do that using SQL. We’re going to improve the UI to include this asap! Though for now, here is how it can be accomplished using the API Explorer:
displayName: "Space Allowed Name",
query: "SELECT statement THAT is SQL"
Once this View is created, it will be visible within your Data Builder.
Secondly, what format do you need your data in? We don’t integrate with Stitch currently, but I do know Bob Moore the founder! Maybe it’s worth me reaching out