Is there a library to generate DDL based on databasemetadata?

Question

Java

You need to get the DDL of objects (tables, views, procedures, etc.) from the corresponding JDBC driver. It is desirable that you still be able to set the template itself,
for example like this:

CREATE TABLE $table_name (
  {for $column in $table_name.columns}
  $column.name $column.type $column.constraints,
...
)

Answer 1

It looks like SchemaCrawler is what you need, there are even templates on Velocity.