Not sure how feasible, but maybe one would like to have conditions for other states than weather as well, to avoid listing many auras in scripts. Drawback is that this list would be manually assembled and not available via API, thus needs per-patch updates. Relevant would be those with common mechanics most likely, here for 9.0.1.35213. Note that underground/flying abilities of course also have untargetable.

List is made by SELECT BattlePetAbilityID, LuaName AS BattlePetStateLuaName FROM BattlePetAbilityState, BattlePetState WHERE BattlePetAbilityState.BattlePetStateID = BattlePetState.ID AND (BattlePetState.LuaName LIKE "Mechanic_%" OR …) (-equivalent in LibreOffice).

Where are you running that SQL?

Sorry, that SQL is not actually what I ran. wow.tools/dbc allows you to download dbs as csv, which in this case I then joined as per that query to produce the table.

There are db2-to-sql converters iirc, but I don’t use them, so I can’t link or describe them, sorry. I can try to find a link for you if needed.

Either way, I’m not sure if this is a good idea: it does require quite frequent updates, and I doubt people really write that generic scripts. This was mostly a result of that weather issue and looking at other effects but weather.

Then again, this information is visible to the battle api at least, but I have not checked if you can get them from the UI api.