It's not something that's built in, but it might be possible for some use cases.
You could set up a trigger that runs on insert or update, which connects to a HTTP endpoint of a push notification gateway (e.g. Expo provides one of these if you're working in their framework).