What is the application of Embedded SQL? or in specific Pro C? [on hold]

What is the current application this Embedded SQL is used? For eg: SQL could be used with Java, there are frameworks like Spring. What is the advantage we get from it? What is the peculiarity of this language?