Please post statistical studies and charts that show the breakdown of violent acts committed by mentally ill patients based on the diseases they were diagnosed as having.
Identify whether "higher rates of violence" is comparing those rates among the population in general or only among the population of known, diagnosed individuals with mental illnesses.
Often, people who commit violence are abusing alcohol and/or narcotics, both illegal and prescribed. Use of drugs, and withdrawal from habitual use, increases the potential for violence exponentially in both the general population and the mentally ill. It's not unreasonable to assume the majority of violent mentally ill patients commit those acts of violence more as a side-effect of the drugs they take, Rx or self-medicating, and not the disease itself.
I don't answer irrelevant questions. it's an academic exercise with no value.
A simple diagnosis alone is not a very reliable predictor but once someone is diagnosed. A diagnosis is just the first step towards identifying someone who may be dangerous.
"The two best predictors are actuarial strategies,15 which focus on diverse demographic and behavioural histories, and use of the HCR-20 (Historical, Clinical, Risk Management), a 20-item checklist designed to estimate the probability of future violence."
https://www.ncbi.nlm.nih.gov/pmc/articles/PMC6019348/I did not find a list that broke down violence rates by diagnosis. I did find some results that showed certain mental disorders have much higher rates, when combined with substance abuse, than the normal population. So one takeaway could be that if you know someone with schizophrenia who is also abusing drugs, that can serve as a more reliable predictor of violence. Again, this would need to be decided on a case by case basis and the above mentioned 20 item checklist would give us a better predictor of how violent someone will be.
Sometimes certain symptoms present with a mental health diagnosis showed higher rates of violence. For example "Mentally ill patients with threatening, paranoid delusions are twice as likely to become aggressive compared with nonparanoid psychotic patients."
And it isn't just a biological mental illnesses either "As many as 70 percent of patients with brain injury secondary to blunt trauma exhibit irritability and aggression."
https://www.ncbi.nlm.nih.gov/pmc/articles/PMC2686644/Suicides correlated highly with someone who was suffering depression at the time. Usually I don't consider suicide into violence rates but since it comprises about 2/3rds of gun deaths it isn't a statistic we can ignore either.
Seeing as how you recognize the role substances have come into play in violence, what is your suggestion in how to address those with mental health issues that are being combined with substance abuse? You recognize a problem but are providing no alternative to red flag type laws. You admit there is a certain group of individuals that do pose an increased risk but are silent on what to do about it.
So lets modify the scenario so it is unavoidable for you. Your brother has schizophrenia and has recently taken up abusing alcohol. He has shown an increase in aggressive tendencies and now wants to buy a gun. You suggest he see a mental health professional but he refuses. What do you do absent any sort of red flag law to address this?