This is interesting. It's perhaps worth mentioning before we get _too_ excited that lots of barbs, loaches, catfish, even tetras occur in brackish water. While I'm not 100% convinced about clowns, horseface loaches certainly do occur in brackish water. Among the barbs are ticto barbs, and from the tetras are x-ray (pristella) tetras. In the catfish camp there's all kind of stuff. Only this week scientists "discovered" that one species of Pangasius actually goes into the sea for part of the year.
On the other hand, randomly sticking fish into brackish water is something to be careful about. Up to about SG 1.003 you're unlikely to cause problems with hardy fish because that amount of salt will have minimal effect on their ability on osmoregulate. But once you go above that, and especially at the SG 1.005 level, freshwater fish are going to get stressed. A lot of stuff is going to be distinctly short-lived if maintained at this sort of salinity. Most freshwater fish will die quickly at the SG 1.010 level preferred by monos, scats, etc.
The split broadly falls between primary and secondary freshwater fish. Primary freshwater fish (carps, characins, catfish, knifefish, arowanas, gouramis, etc.) tend to have very low salt tolerances. Secondary freshwater fish (killifish, cichlids, livebearers) tend to have high salt tolerances. A third group, known as peripheral freshwater fish that are basically freshwater members of otherwise marine families (puffers, gobies, sleepers, halfbeaks, needlefish) have very high tolerances. Of course there are lots of exceptions and extremes. Guppies can be adapted to seawater, but platies can't; Corydoras don't like salt all that much, but their close relative Hoplosternum litorrale is very common in brackish water. So it pays to do some research first.
There's plenty of empirical evidence from laboratory experiments that large deviations from the normal salinity a fish is exposed to causes long term harm, even death. Sure, not every singly species has been tested, but where lab work has been done, it's pretty conclusive: fish live longer and stay healthier at salinity levels close to those they experience in the wild.
Cheers, Neale
We have a very nice comunity of supposed non-brackish fish mixed with brackish fish. Brackish fish such as puffers and knife fish, mixed with typical fresh fish like clown loaches and barbs.