Not sure to which of these I should respond. :-) In approximately chronological order:
1. IMHO inline equations should never be long. If it's long enough to give you margin/column width headaches, I'd do it display mode, which gives you access to multiline equation formats. 2. Rotating a table in a float should be simple (no ERT required). Put the table in a table float, right click the handle of the float, pick Settings, and check "Rotate sideways". 3. Don't know about putting captions above rotated tables. Too kinky for me.