How to convert LineString to MultiineString layer in sqlite?
In QGIS you can use the vector tool: Vector->Geometry Tools->Single parts to Multipart
Singles parts must have a same attribute to became a multipart. and finally you can load it in spatialite.
We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.