Support primary key specified after the fields

[paralin]

The following new test should probably pass (PRIMARY KEY after the fields):

ldiff --git a/sql/query/create_test.go b/sql/query/create_test.go
index 54c09e2..55520a2 100644
--- a/sql/query/create_test.go
+++ b/sql/query/create_test.go
@@ -28,6 +28,7 @@ func TestCreateTable(t *testing.T) {
 		{"If not exists, twice", "CREATE TABLE IF NOT EXISTS test;CREATE TABLE IF NOT EXISTS test", false},
 		{"With primary key", "CREATE TABLE test(foo TEXT PRIMARY KEY)", false},
 		{"With field constraints", "CREATE TABLE test(foo.a[1][2] TEXT primary key, bar[4][0].bat INTEGER not null, baz not null)", false},
+		{"With primary key after", "CREATE TABLE test(a TEXT, PRIMARY KEY(`id`));", false},
 		{"With no constraints", "CREATE TABLE test(a, b)", false},
 		{"With coherent constraint(common)", "CREATE TABLE test(a DOCUMENT, a.b ARRAY, a.b[0] TEXT);", false},
 		{"With coherent constraint(any)", "CREATE TABLE test(a, a.b[0] TEXT);", false},

[paralin]

For reference the default SQL library will generate this query

[asdine]

Thanks @paralin ! Indeed, we don't support yet this syntax but we definitely want to.

[paralin]

Looking forward to it. I am making a proof of concept / demo of running gogs (Git service) - which uses Go-Orm - on top of GenjiDB. This was the current blocker. If solved, I will be able to move onto the next blocker ;)