What is the use of the select statement in SQL(ite) triggers?
In a trigger body, the result of a SELECT statement is simply thrown away.

Using a SELECT statement makes sense only for its side effects, i.e., when using a user-defined function, or RAISE().