A set of PL for autotesting?

Question

Software testing

Hello!
I am looking at the direction of automated software testing and, as it usually happens, there was uncertainty in choosing a priority programming language in relation to the activities of a tester.
On some resources they write that Java is more preferable, since most commercial projects are heavily tied to it (it's easier to maintain, it's easier to ask the development team for advice). In light of the spread of the web and Java-like languages, it's hard to disagree with this.
On others, it doesn’t matter “what” to test, and in this case, Python is preferable due to its easy syntax, many libraries and the reputation of “a language that automates EVERYTHING”, supposedly it is easier to conduct security tests and continuous testing when using CI / CD.
I am not familiar with Java in combat conditions, but I have an idea about the syntax of the language. I use Python in my personal data analysis projects.
I would like to ask QA practitioners what is the truth - what is your choice based on in the first place?
As I understand it, anyway, the set of libraries and frameworks for software testing in Python, Java, and any other PL do not completely intersect in their functional purpose.
That is, complete or almost complete universality in testing is not provided by any of the PLs. Or I'm wrong?

I do not take into account the story that the wider the competence, the better, and it would be nice to know all two or three PLs. I agree with this, but I would like to know what people do in practice.

Answer 1

Here is the thing: you come, for example, to a project as a tester, and there all the tests are already written in spock + groovy + cucumber and the front is tested with some other jest. The choice, it turns out, has already been made before you.

Answer 2

Popularity of PL in the Moscow QA/QC market