Looking up the prepaid SIM card market in Canada it seems that the reasonably priced options for my needs (2GB of data) are only available in the "tablet" plans. However it's not clear if those SIM cards still allow one to make calls and receive/send text messages if you insert them into a regular phone. The official websites (e.g. Bell's) make no mention about it.
Could anyone confirm it's actually possible or impossible? I know I can use Skype to make calls but it's convenient to have a regular local number you can give you to people. There is a blog post from 2014 that mentions that it does work, but things might have changed over the years.