Whoa Nellie wrote:
On 1:28 of this clip from the episode Qpid:
Q to Picard about Vash: "She's found a vulnerability in you... a vulnerability I've been looking for for years. If I had known sooner, I would have appeared as a female
I think Picard simply considered Q his friend at the end of the series (because Q had helped him so many times). That line in Qpid doesn't tell anything about Picard's feelings towards Q but it does tell about Q's feelings towards Picard. And it seems pretty clear what they are. As for that scene in Tapestry, Picard never asked Q to appear in bed with him.