Hi @Ambrose, thanks for the post. At a high level, you can think of Collections as tables, and collection items as records. There is not a select query per say, but you can set filters and limits etc on the Dynamic List wrappers, which could be equated with the concept of a select query.
i.e. if you have a collection of blog posts(a table) and each blog post is a collection item(record) and you can display a list of the collection items using a dynamic list (select query).
The dynamic list goes further than a query in that you can bind your html elements to the fields in the collection.
That may not be the best analogy, but a basic comparison. Check out the CMS lessons to get a full overview how to use the CMS: http://help.webflow.com/lesson/what-is-the-webflow-cms