We have a given equation:
$$\int_0^\alpha f(x)\ dx = \theta$$
with $f(x)$ and $\theta$ given.
$$\theta>0,$$ $$f(x) > 0 \text{ for all } x$$
What would be the most generic way to calculate $\alpha$? Numerical methods are allowed.
If no generic way exists, how could we calculate it for eg. $f(x) = \sin^2 x + 1$?
First of all, Welcome to the site !
As already said in comments and answers, most of the time, you will need a numerical method and Newton will be the simplest (just remember that $x=\cos(x)$ does not show solutions).
For sure, I admit that you have been able to compute the required antiderivative. $$\int f(x)\ dx =F(x) \implies\int_0^\alpha f(x)\ dx = \theta \implies F(\alpha)= F(0)+\theta $$
Starting for a reasonable guess $\alpha_0$, the method will update it according to $$\alpha_{n+1}=\alpha_{n}-\frac{F(\alpha_{n})-F(0)- \theta} {f(\alpha_{n})}$$
For the simle example you give, you have $$F(x)=\frac{3 }{2}x-\frac{1}{4} \sin (2 x)$$ which will give, after some trigonometric simplifications, $$\alpha_{n+1}=\alpha_{n}+\frac{ \sin (2 \alpha_{n} )-6 \alpha_{n}+4 \theta }{3-2 \cos (2 \alpha_{n} )}$$ and a simple guess could be $\alpha_0=\frac 23\theta$.
Let us try using $\theta=123.456$. Then, the iterates will be $$\left( \begin{array}{cc} n & \alpha_{n} \\ 0 & 82.3040000000000 \\ 1 & 82.4807566822034 \\ 2 & 82.4706953627373 \\ 3 & 82.4706617145300 \\ 4 & 82.4706617141536 \end{array} \right)$$