@mengxin we usually discourage from using SQL queries because of the performance implications if queries are badly written.
If you’re doing a custom query to lookup a notification by its id, it’ll use the primary key index, which should be fine.
Best.