For example, I want to recommend a song of Adele to my friend. Should I say: The Someone Like You by Adele is fantastic. or The Someone Like You from Adele is fantastic. or The Someone Like You of Adele is fantastic. or something else.
I would say that the first is the standard usage and most correct.
The second is not wrong, but it sounds a bit colloquial to me.
The third is incorrect English. With people, you say "of Adele's" with a possessive 's. It means it's her song, rather than a song by her, if that makes sense.