It's a question that has puzzled me for a long time.
Every PDE textbook I've ever seen tells me that, Fourier transform can be used to solve linear constant-coefficient differential equations on an infinite domain, but none of them includes an explanation about what boundary condition is actually used when Fourier transform "kills" the derivative. Some materials, for example this seems to suggest that, the boundary condition is $0$ at $\pm\infty$, but it's not true. A counter example is
$$y'(x)+y(x)=\sin (x)$$
The general solution of this equation is
(* Here's the corresponding Mathematica code *)
DSolve[y'[x] + y[x] == Sin[x], y[x], x]
$$y(x)= c_1 e^{-x}+\frac{1}{2} (\sin (x)-\cos (x))$$
while the solution given by Fourier transform and inverse Fourier transform is
(* Here's the corresponding Mathematica code *)
fou = FourierTransform[#, x, w] &;
fou[y'[x]] + fou@y[x] == fou@Sin[x] /. HoldPattern@FourierTransform[__] :> Y[w]
Solve[%, Y[w]][[1, 1, -1]]
InverseFourierTransform[%, w, x]
$$y(x)=\frac{1}{2} (\sin (x)-\cos (x))$$
Clearly the boundary condition isn't $y(\pm\infty)=0$ or $y'(\pm\infty)=0$.
What boundary condition / restriction is imposed when Fourier transform is used for solving differential equations?
When a given PDE can be solved using the Fourier transform in $L^2(\mathbb{R})$, then the cited material is morally right: If a function in $L^2(\mathbb{R})$ has a limit at $\pm \infty$, then this limit equals $0$. However, as noted by user TrialAndError below, there are functions in $L^2(\mathbb{R})$ which do not converge to $0$ at infinity. Such examples do almost converge to $0$ though, e.g. we have for any $\epsilon>0$ that $|\{x\in \mathbb{R}\setminus B_r(0): f(x)>\epsilon\}|\to 0$ as $r\to\infty$.
As you noted, the solution of your example is not at all converging to zero. This is because arriving at this solution requires the calculus of Fourier transforms of tempered distributions! For example, $\sin(x)$ is not in $L^2(\mathbb{R})$ and its distributional Fourier transform involves Dirac deltas, which are also not in $L^2(\mathbb{R})$. While tempered distributions are a larger space than $L^2(\mathbb{R})$, they still exclude functions that diverge exponentially, which is why Mathematica gives you the particular solution you mention.