Each interaction with the Borg results in them learning more about you. Since they are driven by ultimate evolution through assimilation of worthy beings and cultures, the Q having interactions with the Borg could potentially cause the Borg to learn enough about the Q to make them a genuine threat rather than just a potential one.
My interpretation of
Don't provoke the Borg!
Wasn't so much that the borg were a threat to the Q but that they were a threat to other species in the galaxy.
A Q is (for the sake of argument) an omnipotent being, they could dissolve the entire collective at a whim, they could "cure" the borg attempting to assimilate them, they could simply disappear.
Upon @Xantec's suggestion I looked for the original script. On st-minutiae, we have a script labelled FINAL DRAFT dated 11/14/89 which actually contains this line instead!
Q: Humans are such commonplace creatures. They roam the galaxy looking for something, and they don't even know what it is.
So this at least suggests that ...
If we take Q at his word, then the answer is yes. He explicitly states that Picard is his friend in TNG: Deja Q
Q: Because in all the universe you're the closest thing I have to a friend, Jean-Luc.
and again in TNG: Qpid
Q: Oh, and I was hoping for something more along the lines of, welcome back, Q, it's a pleasure to see you again my old friend.
I would argue Yes
I have collected several pieces of evidence which, collectively, I think could be construed as an indication that Q considered Picard to be his 'friend' (although the feeling probably wasn't mutual).
In early 2367, Q defied orders of the Continuum and interfered with
the Enterprise-Ds encounter with Locutus of Borg by keeping the
Riker is not literally questioning whether the setting is a real place or a simulation. He is speaking about Amanda's infatuation.
AMANDA: Don't you like me? Even just a little bit?
RIKER: You're a very lovely young lady. But none of this is real.
AMANDA: My feelings are real.
RIKER: I know. But you can't make someone love you.
The line ...
As we know from DS9 there are directives in effect in starfleet since the Enterprise met Q.
This means that LATEST when the Borg assimilated even a single starfleet member they gained knowledge that Q exists.
And when they assimilated Picard they knew about Qs interest in the human race (if not prior to it already which we don't know, as we don't know how ...
Not Canonically. While the canon policy of Star Trek is vague, and the best I can find of it is on wikipedia here or on the wayback machine from the official site here, it is still clear that media which isn't branded Star Trek is out since even media which is isn't necessarily in. Given what we know about Q, it is certainly conceivable that Q and discord ...
While the episode does not outright say as much, it is highly likely that Q is referring to the events of the episode Q Who, where Q sends Picard and the Enterprise-D into uncharted space where it encounters the Borg. This chance encounter - while later ret-conned as not being the first encounter between the Federation and the Borg - enables the Federation ...
The current convention is that IQ test results are scaled to fit a normal distribution with mean 100 and standard deviation 15. This means that an IQ of 2005 corresponds to a score which is 127 standard deviations above the mean (since (2005-100)/15=127), which would mean that roughly 1 in 10^3505 people are as intelligent as Q is.
The population of the ...
Picard was captain of the Flagship of the Federation of Planets.
Being such, Q probably knew that Picard was the person to represent the Federation and Humanity itself.
It could have been a random coincidence that Picard was the captain in that instance, but that's probably why Q chose him and the Enterprise.
Humanity itself was put on trial because we ...
Q1 (De Lancie) is referring to the fact that Q2 (Quinn) saved Riker's relative; Colonel Thaddius "Iron Boots" Riker at the Battle of Kennesaw Mountain in 1864. Because of this intervention, Cmdr. William T. Riker exists in the future and was therefore able to prevent the Borg invasion of Earth in 2366 (TNG : Best of Both Worlds).
Please note that all my ...
Yes. In the episode "Death Wish", the Q known as Quinn (AKA Q2) takes the Voyager back in time to the Big Bang itself.
TUVOK: Captain, based on our readings, it appears that we have been transported back in time to the birth of the universe.
Janeway looks sharply at Q2 who smiles as he watches the viewscreen... acknowledging.
Q2: Very old ...
The original screenplay would suggest that Riker recognises that it's too perfect. It's quite literally the romance scene from a (bad) holo-novel with just the right amount of moonlight peeking through the perfectly spaced gazebo struts deep within the world's least realistic forest.
31 EXT. A GAZEBO - NIGHT (OPTICAL)
in the woods, as Amanda and ...
Whether any given individual manifested by Q is "real" or not is debatable, and probably varies from one instance to another. The Next Generation episode True Q does show that the Q are capable of creating "real" people:
[Q] then reveals that Rogers is a Q, shocking everyone else. When Crusher claims Rogers' birth parents were Human, Q reveals they were ...
It is not certain if Guinan and Q waged a war together, all we know is that they knew each other from before.
Star Trek memory alpha wiki:
Guinan had "some dealings" with Q sometime during the 22nd century and
indeed other members of the Q Continuum, some of whom she said "were
almost respectable". Her exact relationship with Q remains unclear,
The Q known as Quinn (from the Voyager episode Death Wish) gives us a hint that almost sounds like their powers are a technological achievement rather than an innate biological ability:
TUVOK: I am curious. Have the Q always had an absence of manners? Or is it the result of some natural evolutionary process that comes with omnipotence?
QUINN: What? Oh, ...
Within the TV canon, The Q actually seem pretty limited as supposedly omnipotent beings go. On several occasions we see them die or suffer serious injury, make serious errors of judgement in predicting the intentions of 'lesser beings', they can suffer from evident depression, they're capable of removing each other's powers (when acting in unison) and ...
The Q fear the Borg in roughly the same way you fear taking care of your neighbor's miniature poodle for the weekend. The likelihood of his truly injuring you is minimal, to put it mildly. At the same time, it is entirely possible he might pee on your carpet or chew up your favorite slippers, neither of which is likely to make you particularly happy.
There are just so many ways a Q could avoid being assimilated that this seems an impossible scenario.
But, for the sake of argument, suppose they managed it1.
We know that the Borg incorporate biological traits from assimilated species. We're told this explicitly, and fairly frequently.
We are also led to believe that the power of the Q is biological - ...
If memory serves, by nature, the Q do not have corporeal bodies. They create them at will in order to better interact with humans.
"The Q evolved over countless centuries into their current form and considered themselves to be the ultimate form of evolution, existing in a state of "ultimate purity"."
- "Q (species)", Memory Alpha (Wikia)
I would ...
Nature of the Q continuum
The Q continuum is an extradimensional realm, and as such exists outside the space-time continuum of the universe as we perceive it.
It is highly likely, as extradimensional beings, that the Q can travel through time in our universe. Our universe is either a spacetime submanifold of the larger Q continuum or are two disconnected ...
Picard says that Q was in no danger because the crewman only had his phaser set on stun.
Q tells him that given that they both know how dangerous and savage humans are, that even being stunned is something to be frantically avoided, even to the point of defending oneself with lethal force.
Q: Knowing humans as thou dost, Captain, wouldst thou be ...
The short answer is that we don't know. There is only one mention of the Douwd in the TNG series (in Survivors) and no further mentions of them in any canon property including the other TV series, films or canon 'ongoing' comics.
Moving down the food chain into the EU novels and comics, the answer is we don't know. There are ...
Q wears two distinct types of uniform;
Uniforms that he wears to mock humanity (typically Picard) as being an aggressive, violent child-like race
... the same humanoid face and figure as with the Elizabethan dress, but now the green officer's uniform of the U.S. Marine Corps. Over his jacket pocket three rows of medals and his narrow garrison cap shows ...
Trelane only appears in The Squire of Gothos, in the original Star Trek. He never appears again or is referenced again in canon. (In Trek, canon generally refers to what we see on the TV shows and movies and excludes printed material, but it can vary depending on whom you ask and how rabid they are.)
However, Trelane appears in non-canon works, as ...
The John DeLancie Q was a loquacious character who was always turning phrases and being melodramatic. One of my favorites was this one, where Q has regained his powers, thanks to the exploits of the Enterprise
Au contraire, mon capitaine!
Q would continue to refer to Picard as "Mon capitaine" for the rest of the series.
I've come across a semi-canonical answer on Memory-Beta, primarily from the novels The Buried Age and Q & A.
Humanity came to the attention of Q in early 2364, when Giriaenn, the last of the Manraloth, ascended from the corporeal plane. Giriaenn told Q of her recent experiences with the human Jean-Luc Picard and Q, believing that this Picard might be "...
At that point, it was clear that Q had the ability to manipulate space/time. However, the extent of these abilties was not known (he asks the comm stations to not make transmissions so that Q won't "hear" them). By fleeing, you can:
Give yourself time to come up with a plan while the pursuer catches up (assuming Q didn't just appear). This can be seen with ...