Example (this is past-tense narrative):
I thought about the motivation of the killer. Did he hate his wife?
I thought about the motivation of the killer. Had he hated his wife?
I did some research and found out that using "had" to start a question is archaic or more likely to be found in British English.
I'm not a native English speaker, so I'm a little confused about this.