The solution is for every church to install metal detectors and hire security guards.
But then they’ll pass a law that says that you still have to let people bring their guns into church. Because, you know, Jesus said “let no-one prevent this Judeo-Christian conservative straight white male from coming to me, even if he might shoot someone, for no-one comes to the Father except he be packing heat.”