FluentQuery query = FluentJPA.SQL((Link link) -> {

    INSERT().INTO(viewOf(link, Link::getUrl, Link::getName));
    VALUES(row("http:https://www.google.com", "Google"),
           row("http:https://www.yahoo.com", "Yahoo"),
           row("http:https://www.bing.com", "Bing"));
});

List<Link> links = ... //external parameter

FluentQuery query = FluentJPA.SQL((Link link) -> {

    View<Link> viewOfLink = viewOf(link, Link::getUrl, Link::getName,
                                         l -> l.getStore().getId());

    INSERT().INTO(viewOfLink);
    VALUES(viewOfLink.from(links));
});

FluentQuery query = FluentJPA.SQL((Link link) -> {

    INSERT().INTO(viewOf(link, Link::getUrl, Link::getName, Link::getLastUpdate));
    VALUES(row("http:https://www.facebook.com", "Facebook", DATE.of("2013-06-01")));
});

Link toInsert = ... //external parameter
int storeId = ... //external parameter

FluentQuery query = FluentJPA.SQL((Link link) -> {

    View<Link> viewOfLink = viewOf(link, Link::getUrl, Link::getName,
                                                       l -> l.getStore().getId(),
                                                       Link::getLastUpdate);
    INSERT().INTO(viewOfLink);
    VALUES(viewOfLink.from(toInsert, storeId, DEFAULT()));
    // overrides come at the end  ---^^^^^^^^^^^^^^^^^^
    // I.e. FluentJPA starts populating from the end,
    // and rest of parameters "takes" from the entity
    // (url and name in this example)
});

// same structure - derivation
@Tuple
@Table(name = "link_tmp")
public static class LinkTmp extends Link {
}

FluentQuery query = FluentJPA.SQL((LinkTmp linkTmp,
                                   Link link) -> {
    INSERT().INTO(linkTmp);
    SELECT(link);
    FROM(link);
    WHERE(link.getLastUpdate() != null);
});