I know that for $f$ an integrable function, it's Fourier transform may not be integrable, so the inversion theorem does not necessarily hold.
Assume $f$ is square-integrable instead. Does this imply that the inversion theorem holds, i.e. we can recover $f$ by integrating its Fourier transform? If not, what further assumptions are required?
I am getting different information from different notes online. Some say above is enough, others say that we need some continuity properties, and yet others say that the inversion theorem does not hold pointwise but only in $L^2$ sense?
The Fourier transform is always defined, but you have to work with tempered distributions. In what follows I will use the following definition of Fourier transform $$\mathcal F(\phi)(\xi) := \int_{\mathbb R^n}\phi(x)\exp(-2\pi i x \xi)dx$$ for $\phi \in L^1(\mathbb R^n)$.
The Fourier transform is also defined for the space $\mathcal S'(\mathbb R^n)$ of tempered distributions, and it is indeed a isomorphism. The Fourier transform in this case is given by $$\langle \mathcal F(u),\phi\rangle:= \langle u, \mathcal F(\phi) \rangle,$$ for $\phi \in \mathcal S(\mathbb R^n)$, the Schwartz space of $\mathbb R^n$.
The space $L^2(\mathbb R^n)$ is contained in $\mathcal S'(\mathbb R^n)$, and restricting the Fourier Transform to it we obtain the isomorphism: $$\mathcal F: L^2(\mathbb R^n) \to L^2(\mathbb R^n). $$
Furthermore, this isomorphism is an isometry, that is, $$\Vert \mathcal F(\phi) \Vert = \Vert \mathcal \phi \Vert.$$ This identity is called Placherel theorem.
For a more detailed discussion about this I recommend you to take a look at Folland's book Real Analysis, and at the Fourier Analysis: An Introduction, by Stein and Shakarchi .