I've started a Git Repo dedicated to Canvas Data Queries:
Over the next few days I'll be uploading everything I've written so far. I'm also going to be collecting various queries within this community and adding them to it. If you're interested in contributing, please contact me. I (and a colleague) maintained a large repo for Blackboard stuff also and couldn't find anything specific to Canvas Data, so I created this.
Thanks for sharing, these are useful.
There's a collection of queries scattered in the community, shared on the CanvasLMS Awesome List. Unfortunately, it's uneditable in the current platform otherwise I'd add this. Hopefully soon.
We need more people sharing their own queries like this.
I'm thinking of building a "Wiki" where we can share our codes with the community. Having a wiki will allow us to organise all code snippets, guides, etc. in one place.
I've built a sample wiki page here https://wiki.jerrynguyen.work
Let me know what you think and if you're interested, we can start building this page.